435: IS
436: SELECT /*+ ORDERED
437: USE_NL(PPA, PPR, PAF, HAS)
438: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
439: INDEX(PPR PAY_POPULATION_RANGES_N4)
440: INDEX(PAF PER_ASSIGNMENTS_F_N12)
441: INDEX(HAS HR_ASSIGNMENT_SET_AMENDMEN_PK) */
442: paf.assignment_id
443: FROM pay_payroll_actions ppa,
440: INDEX(PAF PER_ASSIGNMENTS_F_N12)
441: INDEX(HAS HR_ASSIGNMENT_SET_AMENDMEN_PK) */
442: paf.assignment_id
443: FROM pay_payroll_actions ppa,
444: pay_population_ranges ppr,
445: per_assignments_f paf,
446: hr_assignment_set_amendments has
447: WHERE ppa.payroll_action_id = c_payroll_action_id
448: AND ppr.payroll_action_id = ppa.payroll_action_id
502: IS
503: SELECT /*+ ORDERED
504: USE_NL(PPA, PPR, PAF, HAS)
505: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
506: INDEX(PPR PAY_POPULATION_RANGES_N4)
507: INDEX(PAF PER_ASSIGNMENTS_F_N12)
508: INDEX(HAS HR_ASSIGNMENT_SET_AMENDMEN_PK) */
509: paf.assignment_id
510: FROM pay_payroll_actions ppa,
507: INDEX(PAF PER_ASSIGNMENTS_F_N12)
508: INDEX(HAS HR_ASSIGNMENT_SET_AMENDMEN_PK) */
509: paf.assignment_id
510: FROM pay_payroll_actions ppa,
511: pay_population_ranges ppr,
512: per_assignments_f paf,
513: hr_assignment_set_amendments has
514: WHERE ppa.payroll_action_id = c_payroll_action_id
515: AND ppr.payroll_action_id = ppa.payroll_action_id