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_LOCATIONS

Line 1317: from hr_locations_all

1313: RETURN varchar2 IS
1314:
1315: cursor c_location(cp_location_id in number) is
1316: select location_code
1317: from hr_locations_all
1318: where location_id = cp_location_id;
1319:
1320: lv_location_name VARCHAR2(240);
1321: lv_exists VARCHAR2(1);

Line 2502: from hr_locations hl,

2498: address_line_3, town_or_city,
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:

Line 2892: from hr_locations hl,

2888: psps.effective_end_date;
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: