DBA Data[Home] [Help]

APPS.PAY_CA_T4_XML dependencies on PAY_MAGTAPE_GENERIC

Line 283: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

279: pay_payroll_actions ppa,
280: pay_assignment_actions paa1,
281: pay_payroll_actions ppa1
282: where ppa.payroll_action_id = paa.payroll_action_id
283: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
284: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
285: and fnd_number.canonical_to_number(substr(paa.serial_number,3,14)) = paa1.assignment_action_id
286: and paa1.payroll_action_id = ppa1.payroll_action_id
287: and ((ppa1.report_type = decode(ppa.report_type,'T4_XML','T4','PAYCAT4AMPDF','CAEOY_T4_AMEND_PP')

Line 284: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

280: pay_assignment_actions paa1,
281: pay_payroll_actions ppa1
282: where ppa.payroll_action_id = paa.payroll_action_id
283: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
284: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
285: and fnd_number.canonical_to_number(substr(paa.serial_number,3,14)) = paa1.assignment_action_id
286: and paa1.payroll_action_id = ppa1.payroll_action_id
287: and ((ppa1.report_type = decode(ppa.report_type,'T4_XML','T4','PAYCAT4AMPDF','CAEOY_T4_AMEND_PP')
288: and ppa.report_type <> 'PAYCAT4CLPDF') or (ppa.report_type = 'PAYCAT4CLPDF' and

Line 332: open c_get_report_type(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));

328: hr_utility.trace('l_type ' ||l_type);
329: hr_utility.trace('l_print ' ||l_print);
330: hr_utility.trace('l_prov ' ||l_prov);
331: /*Added for Bug#10359114 */
332: open c_get_report_type(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
333: fetch c_get_report_type into l_report_type;
334: close c_get_report_type;
335:
336: if l_report_type = 'PAYCAT4CLPDF' then