DBA Data[Home] [Help]

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: