APPS.PO_SHARED_PROC_PVT dependencies on HZ_LOCATIONS

Line 850: FROM HZ_LOCATIONS

846: --international drop ship scenerio.
847: BEGIN
848: SELECT 'Y'
849: INTO l_is_customer_location
850: FROM HZ_LOCATIONS
851: WHERE nvl(address_expiration_date, trunc(sysdate + 1)) > trunc(sysdate)
852: AND location_id = l_deliver_to_location_id;
853: EXCEPTION
854: WHEN NO_DATA_FOUND THEN