APPS.PAY_JP_UITE_ARCH_PKG dependencies on PER_PEOPLE_F

Line 2069: ' FROM per_people_f p,' ||

2065: -------------------------------------------------------------------------
2066: -- sql string to SELECT a range of assignments eligible for archival.
2067: -------------------------------------------------------------------------
2068: p_sql := ' SELECT distinct p.person_id' ||
2069: ' FROM per_people_f p,' ||
2070: ' pay_payroll_actions pa' ||
2071: ' WHERE pa.payroll_action_id = :payroll_action_id' ||
2072: ' AND p.business_group_id = pa.business_group_id' ||
2073: ' ORDER BY p.person_id';

Line 2406: FROM per_people_f PPF

2402: IS
2403: SELECT PAF.assignment_id
2404: ,PPS.actual_termination_date
2405: ,PPS.projected_termination_date
2406: FROM per_people_f PPF
2407: ,per_assignments_f PAF
2408: ,per_periods_of_service PPS
2409: ,pay_population_ranges PPR
2410: ,pay_payroll_actions PPA

Line 2442: FROM per_people_f PPF

2438: IS
2439: SELECT PAF.assignment_id
2440: ,PPS.actual_termination_date
2441: ,PPS.projected_termination_date
2442: FROM per_people_f PPF
2443: ,per_assignments_f PAF
2444: ,per_periods_of_service PPS
2445: WHERE PPF.person_id = PAF.person_id
2446: AND PPF.person_id = PPS.person_id

Line 2678: FROM per_people_f PPF

2674: , PAF.assignment_id ASSIGNMENT_ID
2675: , PAF.payroll_id PAYROLL_ID
2676: , PPOS.date_start HIRE_DATE
2677: , PPOS.last_standard_process_date LAST_STD_PROCESS_DATE
2678: FROM per_people_f PPF
2679: , per_assignments_f PAF
2680: , per_addresses PAD
2681: , per_periods_of_service PPOS
2682: WHERE PAF.person_id = PPF.person_id