APPS.HR_WPM_MASS_APR_PUSH dependencies on WF_ROLES

Line 3155: FROM wf_roles wf, per_all_people_f ppl

3151:
3152: CURSOR get_role (p_person_id IN per_all_people_f.person_id%TYPE)
3153: IS
3154: SELECT wf.NAME role_name, ppl.full_name
3155: FROM wf_roles wf, per_all_people_f ppl
3156: WHERE wf.orig_system = 'PER'
3157: AND wf.orig_system_id = p_person_id
3158: AND wf.orig_system_id = ppl.person_id
3159: AND TRUNC (SYSDATE) BETWEEN ppl.effective_start_date