APPS.RCV_TRANSACTION_SV dependencies on HZ_LOCATIONS

Line 196: FROM hz_locations

192:
193: IF (x_oe_line_id IS NOT NULL) THEN /* drop ship */
194: SELECT substr(rtrim(address1) || '-' || rtrim(city),1,20)
195: INTO x_location_code
196: FROM hz_locations
197: WHERE location_id = x_location_id;
198: ELSE /* not a drop ship */
199: SELECT location_code
200: INTO x_location_code

Line 384: from hz_locations

380: exception
381: when NO_DATA_FOUND then
382: select 'Check to see if deliver_to_location_id is valid'
383: INTO x_del_loc_val
384: from hz_locations
385: WHERE (address_expiration_date IS NULL
386: OR
387: address_expiration_date > x_date)
388: AND location_id = x_deliver_to_location_id;

Line 420: from hz_locations

416: exception
417: when NO_DATA_FOUND then
418: select 'Check to see if location_id is valid'
419: into x_loc_val
420: from hz_locations
421: WHERE (address_expiration_date IS NULL
422: OR
423: address_expiration_date > x_date)
424: AND location_id = x_location_id;