APPS.WSH_DOCUMENT_SETS dependencies on WSH_TRIPS

Line 180: wsh_trips wt

176: wt.name
177: FROM wsh_new_deliveries del,
178: wsh_delivery_legs dlg,
179: wsh_trip_stops st,
180: wsh_trips wt
181: WHERE del.delivery_id = dlg.delivery_id
182: AND dlg.pick_up_stop_id = st.stop_id
183: AND st.trip_id = wt.trip_id
184: AND del.initial_pickup_location_id = st.stop_location_id

Line 553: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

549: --
550: -- Debug Statements
551: --
552: IF l_debug_on THEN
553: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
554: END IF;
555: --
556: entity_name := WSH_TRIPS_PVT.Get_Name(p_trip_ids(i));
557: elsif (p_stop_ids.count <> 0) then

Line 556: entity_name := WSH_TRIPS_PVT.Get_Name(p_trip_ids(i));

552: IF l_debug_on THEN
553: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
554: END IF;
555: --
556: entity_name := WSH_TRIPS_PVT.Get_Name(p_trip_ids(i));
557: elsif (p_stop_ids.count <> 0) then
558: --
559: -- Debug Statements
560: --