APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on HR_LOCATIONS
Line 592: from wsh_trip_stops_ob_grp_v wts, hr_locations hrl
588: p_trip_id IN NUMBER) IS
589: BEGIN
590: open x_dock_door for
591: select hrl.location_code 592: from wsh_trip_stops_ob_grp_v wts, hr_locations hrl 593: where wts.stop_location_id = hrl.location_id
594: and wts.trip_id = p_trip_id;
595: END get_dock_door;
596: