APPS.PO_COPYDOC_S1 dependencies on PO_VENDOR_SITES

Line 1502: from po_vendor_sites where

1498: po_headers where
1499: po_header_id=x_po_shipment_record.po_header_id;
1500:
1501: select ship_to_location_id into l_to_ship_to_location_id
1502: from po_vendor_sites where
1503: vendor_site_id=l_vendor_site_id;
1504:
1505: if (l_to_ship_to_location_id is null) then
1506: select fsp.ship_to_location_id