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_MMREF_REPORTING_MT dependencies on HR_ORGANIZATION_UNITS

Line 1524: ,hr_organization_units hou

1520: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
1521: FROM pay_assignment_actions paa
1522: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
1523: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
1524: ,hr_organization_units hou
1525: WHERE
1526: ppa.payroll_action_id = cp_payroll_action_id /* W2 payroll_action_id */
1527: and ppa.payroll_action_id = paa.payroll_action_id
1528: and ppa1.legislative_parameters like ltrim(rtrim(to_char(paa.tax_unit_id))) || ' TRANS%'

Line 1573: l_gre hr_organization_units.name%type;

1569: l_state_code varchar2(2);
1570: l_info varchar2(80);
1571: l_flag varchar2(2) := 'Y';
1572: l_control_num_flag varchar2(2) := 'Y';
1573: l_gre hr_organization_units.name%type;
1574: l_message_preprocess varchar2(80);
1575: l_message_text varchar2(200);
1576: u_message_text varchar2(200);
1577: l_control_number number;