DBA Data[Home] [Help]

APPS.PQP_GB_PENSRV_SVPN dependencies on PER_ALL_PEOPLE_F

Line 68: FROM per_all_people_f papf,

64: CURSOR csr_fetch_all_assignments (c_eff_end_date IN Date)
65: IS
66: SELECT DISTINCT papf.national_identifier,papf.person_id,paaf.assignment_id,
67: ppos.period_of_service_id,papf.employee_number,paaf.assignment_number
68: FROM per_all_people_f papf,
69: per_all_assignments_f paaf,
70: per_periods_of_service ppos
71: WHERE papf.business_group_id = g_business_group_id
72: AND papf.effective_start_date <= c_eff_end_date