cursor vc_leave is 
select emp_no from hr_db.hr_emp_m 
where emp_sts = 2 and to_date(nvl((select max(end_date) from hr_db.hr_leaves where empno = emp_no),(select max(end_date) from hr_db.hr_leaves_h where empno = emp_no))) < to_date(sysdate);