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
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