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 1247: from hr_locations_all

1243: RETURN varchar2 IS
1244:
1245: cursor c_location(cp_location_id in number) is
1246: select location_code
1247: from hr_locations_all
1248: where location_id = cp_location_id;
1249:
1250: lv_location_name VARCHAR2(240);
1251: lv_exists VARCHAR2(1);

Line 2405: from hr_locations hl,

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

Line 2779: from hr_locations hl,

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