APPS.PO_POXRVXRV_XMLP_PKG dependencies on HZ_LOCATIONS

Line 379: from hz_locations hz

375: when no_data_found then
376:
377: select substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,20) location_code
378: into x_location_code
379: from hz_locations hz
380: where hz.location_id = location_id1;
381: END;
382:
383: end if;