eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_W2C_RPT dependencies on HR_US_W2_MT

Line 1556: SELECT NVL(TO_DATE(TO_CHAR(TO_DATE(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',

1552: from pay_assignment_actions
1553: where assignment_action_id = p_asg_action_id;
1554:
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:

Line 3623: hr_us_w2_mt.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),

3619:
3620: CURSOR c_get_params IS
3621: SELECT substr(paa.serial_number, 1,15),--W2c Pre process action id
3622: substr(paa.serial_number, 16,15),--Prev pre process action id (W2c pre process/YEPP)
3623: hr_us_w2_mt.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
3624: hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
3625: hr_us_w2_mt.get_parameter('p_instr_template',ppa.legislative_parameters),
3626: hr_us_w2_mt.get_parameter('print_instrunction',ppa.legislative_parameters)
3627: FROM pay_assignment_actions paa,

Line 3624: hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),

3620: CURSOR c_get_params IS
3621: SELECT substr(paa.serial_number, 1,15),--W2c Pre process action id
3622: substr(paa.serial_number, 16,15),--Prev pre process action id (W2c pre process/YEPP)
3623: hr_us_w2_mt.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
3624: hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
3625: hr_us_w2_mt.get_parameter('p_instr_template',ppa.legislative_parameters),
3626: hr_us_w2_mt.get_parameter('print_instrunction',ppa.legislative_parameters)
3627: FROM pay_assignment_actions paa,
3628: pay_payroll_actions ppa

Line 3625: hr_us_w2_mt.get_parameter('p_instr_template',ppa.legislative_parameters),

3621: SELECT substr(paa.serial_number, 1,15),--W2c Pre process action id
3622: substr(paa.serial_number, 16,15),--Prev pre process action id (W2c pre process/YEPP)
3623: hr_us_w2_mt.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
3624: hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
3625: hr_us_w2_mt.get_parameter('p_instr_template',ppa.legislative_parameters),
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

Line 3626: hr_us_w2_mt.get_parameter('print_instrunction',ppa.legislative_parameters)

3622: substr(paa.serial_number, 16,15),--Prev pre process action id (W2c pre process/YEPP)
3623: hr_us_w2_mt.get_parameter('TRANSFER_GRE',ppa.legislative_parameters),
3624: hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
3625: hr_us_w2_mt.get_parameter('p_instr_template',ppa.legislative_parameters),
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');