DBA Data[Home] [Help]

APPS.PAY_NZ_EMS dependencies on PAY_PAYROLL_ACTIONS

Line 229: , pay_payroll_actions pact

225: , pay_run_result_values prrv
226: , pay_run_result_values prrv1
227: -- , pay_run_result_values prrv2 /* 7480679 */
228: , pay_assignment_actions assact
229: , pay_payroll_actions pact
230: , fnd_sessions s
231: , per_periods_of_service pos
232: , per_time_periods ptp
233: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')

Line 283: ,pay_payroll_actions pact4

279: and et2.effective_end_date > et2.effective_start_date
280: )
281: and assact.assignment_action_id = ( select max(assact4.assignment_action_id)
282: from pay_assignment_actions assact4
283: ,pay_payroll_actions pact4
284: ,pay_run_results prr4
285: where assact4.assignment_id = a.assignment_id
286: and assact4.assignment_action_id = prr4.assignment_action_id
287: and pact4.payroll_action_id = assact4.payroll_action_id