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

Line 1192: from hr_organization_units

1188: RETURN varchar2 IS
1189:
1190: cursor c_organization_name is
1191: select name
1192: from hr_organization_units
1193: where organization_id = p_organization_id;
1194:
1195: lv_organization_name VARCHAR2(240);
1196: lv_exists VARCHAR2(1);

Line 2406: hr_organization_units hou

2402: region_1, region_2,
2403: region_3, postal_code,
2404: country, telephone_number_1
2405: from hr_locations hl,
2406: hr_organization_units hou
2407: where hou.organization_id = cp_organization_id
2408: and hou.location_id = hl.location_id;
2409:
2410: lv_ee_or_er VARCHAR2(150);

Line 2780: hr_organization_units hou

2776:
2777: CURSOR er_phone_number(cp_organization_id in number) IS
2778: select telephone_number_1
2779: from hr_locations hl,
2780: hr_organization_units hou
2781: where hou.organization_id = cp_organization_id
2782: and hou.location_id = hl.location_id;
2783:
2784: