DBA Data[Home] [Help]

APPS.PAY_RETRO_NOTIF_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 1472: per_periods_of_service pos,

1468: INDEX(paf PER_ASSIGNMENTS_N12)
1469: USE_NL(pos paf) */
1470: paf.assignment_id
1471: from
1472: per_periods_of_service pos,
1473: per_assignments_f paf,
1474: pay_payroll_actions ppa
1475: where ppa.payroll_action_id = pactid
1476: and paf.payroll_id =

Line 1503: per_periods_of_service pos,

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
1507: and paf.payroll_id = pay_core_utils.get_parameter('PAYROLL_ID', ppa.legislative_parameters)