APPS.PAY_US_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 1469: pay_all_payrolls_f PPY

1465: ,cp_end_person_id in number) is
1466: SELECT DISTINCT
1467: ASG.person_id person_id
1468: FROM per_all_assignments_f ASG,
1469: pay_all_payrolls_f PPY
1470: WHERE exists
1471: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1472: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1473: 'x'

Line 1502: pay_all_payrolls_f ppy

1498: select DISTINCT
1499: asg.person_id person_id
1500: from pay_population_ranges ppr,
1501: per_all_assignments_f asg,
1502: pay_all_payrolls_f ppy
1503: where exists
1504: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1505: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1506: 'x'