APPS.AHL_UTIL_UC_PKG dependencies on PO_VENDOR_SITES_ALL

Line 90: FROM po_vendor_sites_all

86: decode(state,null,null,';'||state) ||
87: decode(zip,null,null,';'||zip) ||
88: decode(province,null,null,';'||province) ||
89: decode(country,null,null,';'||country) Address
90: FROM po_vendor_sites_all
91: WHERE vendor_site_id = p_location_id;
92:
93: CURSOR hr_locations_csr (p_location_id IN NUMBER) IS
94: SELECT decode(address_line_1,null,null,address_line_1) ||

Line 257: FROM po_vendor_sites_all

253: AND status <> 'I';
254:
255: CURSOR ahl_owner_loc_vndr_csr (p_location_id NUMBER) IS
256: SELECT vendor_site_code
257: FROM po_vendor_sites_all
258: WHERE vendor_site_id = p_location_id;
259:
260: l_location VARCHAR2(2000);
261: