APPS.PON_ADD_UTIL_PKG dependencies on HR_LOCATIONS

Line 33: FROM hr_locations hl

29: , hl.bill_to_site_flag
30: , hl.ship_to_site_flag
31: , hl.receiving_site_flag
32:
33: FROM hr_locations hl
34:
35: WHERE hl.location_id = p_location_id;
36:
37: x_status :='S';

Line 128: FROM hr_locations_all_tl

124: BEGIN
125:
126: SELECT location_code
127: INTO x_address_name
128: FROM hr_locations_all_tl
129: WHERE location_id = p_location_id
130: AND language = p_language;
131:
132: END retrieve_hr_location_code;