APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on HZ_LOCATIONS

Line 1268: FROM hz_locations hz

1264: WHEN NO_DATA_FOUND THEN
1265: BEGIN
1266: SELECT location_id
1267: INTO x_location
1268: FROM hz_locations hz
1269: WHERE ( hz.address_expiration_date IS NULL
1270: OR hz.address_expiration_date > SYSDATE)
1271: AND (hz.location_id = x_location_record.location_id);
1272: EXCEPTION