APPS.AHL_UTIL_UC_PKG dependencies on PO_VENDOR_SITES_ALL

Line 85: FROM po_vendor_sites_all

81: decode(state,null,null,';'||state) ||
82: decode(zip,null,null,';'||zip) ||
83: decode(province,null,null,';'||province) ||
84: decode(country,null,null,';'||country) Address
85: FROM po_vendor_sites_all
86: WHERE vendor_site_id = p_location_id;
87:
88: CURSOR hr_locations_csr (p_location_id IN NUMBER) IS
89: SELECT decode(address_line_1,null,null,address_line_1) ||

Line 252: FROM po_vendor_sites_all

248: AND status <> 'I';
249:
250: CURSOR ahl_owner_loc_vndr_csr (p_location_id NUMBER) IS
251: SELECT vendor_site_code
252: FROM po_vendor_sites_all
253: WHERE vendor_site_id = p_location_id;
254:
255: l_location VARCHAR2(2000);
256: