DBA Data[Home] [Help]

APPS.PAY_NZ_EMS dependencies on PAY_PAYROLL_ACTIONS

Line 182: , pay_payroll_actions pact

178: , pay_run_result_values prrv
179: , pay_run_result_values prrv1
180: , pay_run_result_values prrv2
181: , pay_assignment_actions assact
182: , pay_payroll_actions pact
183: , fnd_sessions s
184: , per_periods_of_service pos
185: , per_time_periods ptp
186: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')

Line 234: ,pay_payroll_actions pact4

230: and et2.effective_start_date <= last_day(s.effective_date)
231: )
232: and assact.assignment_action_id = ( select max(assact4.assignment_action_id)
233: from pay_assignment_actions assact4
234: ,pay_payroll_actions pact4
235: ,pay_run_results prr4
236: where assact4.assignment_id = a.assignment_id
237: and assact4.assignment_action_id = prr4.assignment_action_id
238: and pact4.payroll_action_id = assact4.payroll_action_id