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 1262: from hr_organization_units

1258: RETURN varchar2 IS
1259:
1260: cursor c_organization_name is
1261: select name
1262: from hr_organization_units
1263: where organization_id = p_organization_id;
1264:
1265: lv_organization_name VARCHAR2(240);
1266: lv_exists VARCHAR2(1);

Line 2503: hr_organization_units hou

2499: region_1, region_2,
2500: region_3, postal_code,
2501: country, telephone_number_1
2502: from hr_locations hl,
2503: hr_organization_units hou
2504: where hou.organization_id = cp_organization_id
2505: and hou.location_id = hl.location_id;
2506:
2507: lv_ee_or_er VARCHAR2(150);

Line 2893: hr_organization_units hou

2889:
2890: CURSOR er_phone_number(cp_organization_id in number) IS
2891: select telephone_number_1
2892: from hr_locations hl,
2893: hr_organization_units hou
2894: where hou.organization_id = cp_organization_id
2895: and hou.location_id = hl.location_id;
2896:
2897: