DBA Data[Home] [Help]

APPS.PAY_US_EMP_BALADJ_CLEANUP dependencies on PER_ALL_ASSIGNMENTS_F

Line 1435: per_all_assignments_f paf,

1431: select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1432: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1433: paa.assignment_action_id
1434: from pay_assignment_actions paa,
1435: per_all_assignments_f paf,
1436: per_all_assignments_f paf1,
1437: pay_payroll_actions ppa
1438: where paf1.assignment_id = cp_assignment_id
1439: and paf.person_id = paf1.person_id

Line 1436: per_all_assignments_f paf1,

1432: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1433: paa.assignment_action_id
1434: from pay_assignment_actions paa,
1435: per_all_assignments_f paf,
1436: per_all_assignments_f paf1,
1437: pay_payroll_actions ppa
1438: where paf1.assignment_id = cp_assignment_id
1439: and paf.person_id = paf1.person_id
1440: and paa.assignment_id = paf.assignment_id