DBA Data[Home] [Help]

APPS.PQP_GB_LGPS_PENSIONPAY dependencies on PER_ALL_PEOPLE_F

Line 271: per_all_people_f papf,

267: IS
268: SELECT paaf.assignment_id, paaf.assignment_number,
269: paaf.payroll_id, MIN(paaf.EFFECTIVE_START_DATE) EFFECTIVE_START_DATE
270: FROM per_all_assignments_f paaf,
271: per_all_people_f papf,
272: per_assignment_status_types past
273: WHERE paaf.business_group_id = p_business_group_id
274: AND paaf.payroll_id= nvl(p_payroll_id, paaf.payroll_id)
275: -- AND paaf.assignment_id = nvl(p_assignment_id, paaf.assignment_id)