DBA Data[Home] [Help]

APPS.PAY_US_W2C_RPT dependencies on PAY_MAGTAPE_GENERIC

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

1555: CURSOR c_get_session_date IS
1556: SELECT NVL(TO_DATE(TO_CHAR(TO_DATE(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',
1557: ppa.legislative_parameters),'DD-MON-YYYY'),'YYYY/MM/DD'),'YYYY/MM/DD'),SYSDATE) session_date
1558: FROM pay_payroll_actions ppa
1559: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1560:
1561: c_get_session_date_rec c_get_session_date%ROWTYPE;
1562:
1563: FUNCTION get_state_ein (p_jurisdiction in varchar2

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

1619: INTO l_business_group_id;
1620: CLOSE c_get_business_group_id;
1621:
1622: hr_utility.trace('Business Group id ' ||l_business_group_id);
1623: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID ' ||pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1624:
1625: IF l_business_group_id is not null THEN
1626: hr_us_w2_rep.get_agent_tax_unit_id(l_business_group_id
1627: ,p_year

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

3626: hr_us_w2_mt.get_parameter('print_instrunction',ppa.legislative_parameters)
3627: FROM pay_assignment_actions paa,
3628: pay_payroll_actions ppa
3629: where ppa.payroll_action_id = paa.payroll_action_id
3630: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
3631:
3632: BEGIN
3633: --hr_utility.trace_on(null,'w2');
3634: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);