DBA Data[Home] [Help]

APPS.PAY_GB_WNU_RULES dependencies on PER_ALL_PEOPLE_F

Line 27: from per_all_people_f apf,

23: l_ovn_out number(15);
24: --
25: cursor csr_employee is
26: select upper(apf.current_employee_flag)
27: from per_all_people_f apf,
28: per_all_assignments_f aaf
29: where aaf.person_id = apf.person_id
30: and aaf.assignment_id = p_assignment_id
31: and p_effective_date between

Line 186: from per_all_people_f apf

182: l_ni_number_update varchar2(30):= null;
183: --
184: cursor csr_employee is
185: select upper(apf.current_employee_flag)
186: from per_all_people_f apf
187: where apf.person_id = p_person_id
188: and p_effective_date between
189: apf.effective_start_date and apf.effective_end_date;
190: --