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_W2_INFO_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 544: from pay_assignment_actions

540: where organization_id = p_tax_unit_id;
541:
542: CURSOR c_get_payroll_action (p_asg_action_id NUMBER)IS
543: select payroll_action_id
544: from pay_assignment_actions
545: where assignment_action_id = p_asg_action_id;
546:
547: CURSOR c_get_session_date IS
548: SELECT NVL(TO_DATE(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',

Line 1812: FROM pay_assignment_actions paa,

1808: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),
1809: hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
1810: hr_us_w2_mt.get_parameter('p_instr_template',ppa.legislative_parameters),
1811: hr_us_w2_mt.get_parameter('print_instrunction',ppa.legislative_parameters)
1812: FROM pay_assignment_actions paa,
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

Line 1814: pay_assignment_actions paa1,

1810: hr_us_w2_mt.get_parameter('p_instr_template',ppa.legislative_parameters),
1811: hr_us_w2_mt.get_parameter('print_instrunction',ppa.legislative_parameters)
1812: FROM pay_assignment_actions paa,
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')