1533: INDEX(paf PER_ASSIGNMENTS_N12)
1534: USE_NL(pos paf) */
1535: paf.assignment_id
1536: from
1537: per_periods_of_service pos,
1538: per_assignments_f paf,
1539: pay_payroll_actions ppa
1540: where ppa.payroll_action_id = pactid
1541: and paf.payroll_id =
1564: INDEX(paf PER_ASSIGNMENTS_N12)
1565: USE_NL(pos paf) */
1566: paf.assignment_id
1567: FROM pay_population_ranges ppr,
1568: per_periods_of_service pos,
1569: per_assignments_f paf,
1570: pay_payroll_actions ppa
1571: where ppa.payroll_action_id = pactid
1572: and paf.payroll_id = pay_core_utils.get_parameter('PAYROLL_ID', ppa.legislative_parameters)