APPS.POS_CREATE_ASN dependencies on HR_LOCATIONS_ALL

Line 300: (select location_id from hr_locations_all

296: select count(*)
297: into x_pla_count
298: from po_location_associations PLA
299: where pla.location_id =
300: (select location_id from hr_locations_all
301: where location_code = P_SHIP_TO_LOCATION_CODE_T) and
302: pla.vendor_id is not null and pla.vendor_site_id is not null;
303:
304: x_progress := '050' ;