Social Icons

Saturday, April 27, 2019

HR Employee basic information in Oracle EBS

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

No comments :

Post a Comment

">