DBA Data[Home] [Help]

APPS.PAY_RETRO_NOTIF_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 1537: per_periods_of_service pos,

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 =

Line 1568: per_periods_of_service pos,

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)