APPS.PO_VAL_DISTRIBUTIONS2 dependencies on HZ_LOCATIONS

Line 277: FROM hz_locations

273: AND NVL(inactive_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
274: AND location_id = p_deliver_to_location_id_tbl(i))
275: AND NOT EXISTS(
276: SELECT 1
277: FROM hz_locations
278: WHERE NVL(address_expiration_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
279: AND location_id = p_deliver_to_location_id_tbl(i));
280:
281: IF (SQL%ROWCOUNT > 0) THEN