Select papf.employee_number,papf.global_name staff_name ,papf.start_date from per_all_people_f papf
where papf.business_group_id=81
and papf.current_employee_flag='Y'
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
where papf.business_group_id=81
and papf.current_employee_flag='Y'
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
No comments :
Post a Comment