APPS.PAY_PAYSLIP_REPORT dependencies on PER_ALL_PEOPLE_F

Line 33: ,per_all_people_f papf

29: SELECT /*+ ORDERED */ 'TRANSFER_ACT_ID=P',ptoa.object_Action_id
30: FROM pay_temp_object_actions ptoa
31: ,pay_payroll_actions ppa
32: ,per_all_assignments_f paaf
33: ,per_all_people_f papf
34: ,hr_soft_coding_keyflex hsck
35: ,per_business_groups pbg
36: ,hr_organization_units org
37: ,per_person_types ppt

Line 52: FROM per_all_people_f papf_inner

48: TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
49: )
50: --AND paaf.effective_start_date between papf.effective_start_date and papf.effective_end_date
51: AND papf.effective_start_date = (SELECT MAX(papf_inner.effective_start_date)
52: FROM per_all_people_f papf_inner
53: WHERE papf_inner.person_id = papf.person_id
54: AND papf_inner.effective_start_date <=
55: TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
56: )