APPS.AHL_UTIL_UC_PKG dependencies on HR_LOCATIONS_ALL

Line 99: FROM hr_locations_all

95: decode(address_line_2,null,null,';'||address_line_2) ||
96: decode(address_line_3, null,null,';'||address_line_3) ||
97: decode(town_or_city, null,null,';'||town_or_city) ||
98: decode(country,null,null,';'||country) Location
99: FROM hr_locations_all
100: WHERE location_id = p_location_id;
101:
102: CURSOR hz_locations_csr(p_location_id IN NUMBER) IS
103: SELECT hzloc.address1 ||