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.ARP_TMP_PKG dependencies on HZ_LOCATIONS

Line 22: SELECT 'A' FROM hz_locations WHERE location_id = p_location_id;

18: x_msg_data OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER)
20: IS
21: CURSOR c_loc_1 IS
22: SELECT 'A' FROM hz_locations WHERE location_id = p_location_id;
23:
24: CURSOR c_loc_2 IS
25: SELECT location_id FROM hz_locations
26: WHERE country = p_country

Line 25: SELECT location_id FROM hz_locations

21: CURSOR c_loc_1 IS
22: SELECT 'A' FROM hz_locations WHERE location_id = p_location_id;
23:
24: CURSOR c_loc_2 IS
25: SELECT location_id FROM hz_locations
26: WHERE country = p_country
27: AND NVL(p_ADDRESS1,'XXX') = NVL(address1,'XXX')
28: AND NVL(p_CITY ,'XXX') = NVL(city,'XXX')
29: AND NVL(p_POSTAL_CODE,'XXX') = NVL(postal_code,'XXX')