APPS.PO_POXRVXRV_XMLP_PKG dependencies on HZ_LOCATIONS

Line 361: from hz_locations hz

357: when no_data_found then
358:
359: select substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,20) location_code
360: into x_location_code
361: from hz_locations hz
362: where hz.location_id = location_id1;
363: END;
364:
365: end if;