APPS.WSH_DOCUMENT_SETS dependencies on WSH_TRIP_STOPS

Line 179: wsh_trip_stops st,

175: del.initial_pickup_location_id,
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

Line 357: select distinct trip_id from wsh_trip_stops

353:
354:
355: CURSOR c_stop_trip_id_cursor (t_stop_id NUMBER )
356: IS
357: select distinct trip_id from wsh_trip_stops
358: where stop_id=t_stop_id;
359: -- bug 1633386
360:
361: l_select_clause VARCHAR2(250);

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

558: --
559: -- Debug Statements
560: --
561: IF l_debug_on THEN
562: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
563: END IF;
564: --
565: entity_name := WSH_TRIP_STOPS_PVT.Get_Name(p_stop_ids(i));
566:

Line 565: entity_name := WSH_TRIP_STOPS_PVT.Get_Name(p_stop_ids(i));

561: IF l_debug_on THEN
562: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
563: END IF;
564: --
565: entity_name := WSH_TRIP_STOPS_PVT.Get_Name(p_stop_ids(i));
566:
567: --bug 1633386
568: OPEN c_stop_trip_id_cursor( p_stop_ids(i));
569: LOOP