[Home] [Help]
APPS.AHL_UTIL_UC_PKG dependencies on HR_LOCATIONS_ALL
Line 94: FROM hr_locations_all
90: decode(address_line_2,null,null,';'||address_line_2) ||
91: decode(address_line_3, null,null,';'||address_line_3) ||
92: decode(town_or_city, null,null,';'||town_or_city) ||
93: decode(country,null,null,';'||country) Location
94: FROM hr_locations_all
95: WHERE location_id = p_location_id;
96:
97: CURSOR hz_locations_csr(p_location_id IN NUMBER) IS
98: SELECT hzloc.address1 ||