DBA Data[Home] [Help]

APPS.PAY_NZ_EMS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 181: , pay_assignment_actions assact

177: , pay_run_results prr2
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

Line 233: from pay_assignment_actions assact4

229: where et2.element_type_id = et.element_type_id
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