DBA Data[Home] [Help]

APPS.PAY_NZ_EMS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 228: , pay_assignment_actions assact

224: -- , pay_run_results prr2 /* 7480679 */
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

Line 282: from pay_assignment_actions assact4

278: and et2.effective_start_date <= last_day(s.effective_date)
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