[Home] [Help]
1498: select /*+ ordered
1499: INDEX(paf PER_ASSIGNMENTS_N12)
1500: USE_NL(pos paf) */
1501: paf.assignment_id
1502: FROM pay_population_ranges ppr,
1503: per_periods_of_service pos,
1504: per_assignments_f paf,
1505: pay_payroll_actions ppa
1506: where ppa.payroll_action_id = pactid