APPS.PAY_US_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 1165: pay_all_payrolls_f PPY

1161: ,cp_end_person_id in number) is
1162: SELECT DISTINCT
1163: ASG.person_id person_id
1164: FROM per_all_assignments_f ASG,
1165: pay_all_payrolls_f PPY
1166: WHERE exists
1167: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1168: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1169: 'x'

Line 1198: pay_all_payrolls_f ppy

1194: select DISTINCT
1195: asg.person_id person_id
1196: from pay_population_ranges ppr,
1197: per_all_assignments_f asg,
1198: pay_all_payrolls_f ppy
1199: where exists
1200: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1201: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1202: 'x'