APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on HR_LOCATIONS

Line 591: from wsh_trip_stops_ob_grp_v wts, hr_locations hrl

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