APPS.WSH_DOCUMENT_SETS dependencies on WSH_TRIPS

Line 193: wsh_trips wt

189: wt.name
190: FROM wsh_new_deliveries del,
191: wsh_delivery_legs dlg,
192: wsh_trip_stops st,
193: wsh_trips wt
194: WHERE del.delivery_id = dlg.delivery_id
195: AND dlg.pick_up_stop_id = st.stop_id
196: AND st.trip_id = wt.trip_id
197: AND del.initial_pickup_location_id = st.stop_location_id

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

565: --
566: -- Debug Statements
567: --
568: IF l_debug_on THEN
569: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
570: END IF;
571: --
572: entity_name := WSH_TRIPS_PVT.Get_Name(p_trip_ids(i));
573: elsif (p_stop_ids.count <> 0) then

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

568: IF l_debug_on THEN
569: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
570: END IF;
571: --
572: entity_name := WSH_TRIPS_PVT.Get_Name(p_trip_ids(i));
573: elsif (p_stop_ids.count <> 0) then
574: --
575: -- Debug Statements
576: --