APPS.PAY_US_W2_INFO_PKG dependencies on PER_ASSIGNMENTS_F

Line 148: , per_assignments_f paf

144: SELECT 'TRANSFER_ACT_ID=P', mt.assignment_action_id
145: from hr_organization_units hou
146: , hr_locations_all hl
147: , per_periods_of_service pps
148: , per_assignments_f paf
149: , pay_assignment_actions mt
150: , pay_payroll_actions ppa
151: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
152: and mt.payroll_action_id = ppa.payroll_action_id

Line 154: and paf.effective_start_date = (select /*+ push_subq no_unnest */ max(paf2.effective_start_date) from per_assignments_f paf2 --Added Hint for Bug 13506529

150: , pay_payroll_actions ppa
151: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
152: and mt.payroll_action_id = ppa.payroll_action_id
153: and paf.assignment_id = mt.assignment_id
154: and paf.effective_start_date = (select /*+ push_subq no_unnest */ max(paf2.effective_start_date) from per_assignments_f paf2 --Added Hint for Bug 13506529
155: where paf2.assignment_id = paf.assignment_id
156: and paf2.effective_start_date <= to_date('31-DEC-'||hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),'DD/MM/YYYY'))
157: and paf.effective_end_date >= to_date('01-JAN-'||hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),'DD/MM/YYYY')
158: and paf.assignment_type = 'E'