DBA Data[Home] [Help]

APPS.PAY_US_W2_INFO_PKG dependencies on PAY_MAGTAPE_GENERIC

Line 551: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');

547: CURSOR c_get_session_date IS
548: SELECT NVL(TO_DATE(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',
549: ppa.legislative_parameters),'YYYY/MM/DD'),SYSDATE) session_date
550: FROM pay_payroll_actions ppa
551: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
552:
553: c_get_session_date_rec c_get_session_date%ROWTYPE;
554:
555: PROCEDURE print_corrected IS

Line 648: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID ' ||pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));

644: INTO l_business_group_id;
645: CLOSE c_get_business_group_id;
646:
647: hr_utility.trace('Business Group id ' ||l_business_group_id);
648: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID ' ||pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
649:
650: IF l_business_group_id is not null THEN
651: hr_us_w2_rep.get_agent_tax_unit_id(l_business_group_id
652: ,p_year

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

1813: pay_payroll_actions ppa,
1814: pay_assignment_actions paa1,
1815: pay_payroll_actions ppa1
1816: where ppa.payroll_action_id = paa.payroll_action_id
1817: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1818: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
1819: and paa.serial_number = paa1.assignment_action_id
1820: and paa1.payroll_action_id = ppa1.payroll_action_id
1821: and ppa1.report_type = 'YREND'

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

1814: pay_assignment_actions paa1,
1815: pay_payroll_actions ppa1
1816: where ppa.payroll_action_id = paa.payroll_action_id
1817: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1818: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
1819: and paa.serial_number = paa1.assignment_action_id
1820: and paa1.payroll_action_id = ppa1.payroll_action_id
1821: and ppa1.report_type = 'YREND'
1822: and ppa1.action_type = 'X'