DBA Data[Home] [Help]

APPS.PQP_GB_PCSPS_PENSIONPAY dependencies on PER_ALL_PEOPLE_F

Line 309: per_all_people_f papf,

305: IS
306: SELECT paaf.assignment_id, paaf.assignment_number,
307: paaf.payroll_id, MIN(paaf.EFFECTIVE_START_DATE) EFFECTIVE_START_DATE
308: FROM per_all_assignments_f paaf,
309: per_all_people_f papf,
310: per_assignment_status_types past
311: WHERE paaf.business_group_id = p_business_group_id
312: AND paaf.payroll_id= nvl(p_payroll_id, paaf.payroll_id)
313: -- AND paaf.assignment_id = nvl(p_assignment_id, paaf.assignment_id)