DBA Data[Home] [Help]

APPS.PAY_US_W2C_RPT dependencies on PAY_PAYROLL_ACTIONS

Line 216: , pay_payroll_actions ppa

212: , hr_locations_all hl
213: , per_periods_of_service pps
214: , per_assignments_f paf
215: , pay_assignment_actions mt
216: , pay_payroll_actions ppa
217: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
218: and mt.payroll_action_id = ppa.payroll_action_id
219: and paf.assignment_id = mt.assignment_id
220: and paf.effective_start_date = (select /*+ push_subq no_unnest */ max(paf2.effective_start_date) from per_assignments_f paf2