APPS.PAY_US_W2C_RPT dependencies on PAY_MAGTAPE_GENERIC

Line 208: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');

204: --changes for Bug 16398337
205: /* SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
206: FROM pay_assignment_actions paa
207: WHERE paa.payroll_action_id =
208: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
209: */
210: SELECT 'TRANSFER_ACT_ID=P', mt.assignment_action_id
211: from hr_organization_units hou
212: , hr_locations_all hl

Line 217: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

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
221: where paf2.assignment_id = paf.assignment_id

Line 268: pay_magtape_generic.get_parameter_value(

264: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1));
265:
266: CURSOR c_get_asg_action IS
267: SELECT 'TRANSFER_ACT_ID=P',
268: pay_magtape_generic.get_parameter_value(
269: 'TRANSFER_ACT_ID')
270: FROM DUAL;
271:
272: PROCEDURE get_headers ;