APPS.PO_VAL_DISTRIBUTIONS2 dependencies on HZ_LOCATIONS

Line 265: FROM hz_locations

261: AND NVL(inactive_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
262: AND location_id = p_deliver_to_location_id_tbl(i))
263: AND NOT EXISTS(
264: SELECT 1
265: FROM hz_locations
266: WHERE NVL(address_expiration_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
267: AND location_id = p_deliver_to_location_id_tbl(i));
268:
269: IF (SQL%ROWCOUNT > 0) THEN