APPS.WSH_DOCUMENT_SETS dependencies on WSH_TRIP_STOPS

Line 192: wsh_trip_stops st,

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

Line 370: select distinct trip_id from wsh_trip_stops

366:
367:
368: CURSOR c_stop_trip_id_cursor (t_stop_id NUMBER )
369: IS
370: select distinct trip_id from wsh_trip_stops
371: where stop_id=t_stop_id;
372: -- bug 1633386
373:
374: l_select_clause VARCHAR2(250);

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

574: --
575: -- Debug Statements
576: --
577: IF l_debug_on THEN
578: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
579: END IF;
580: --
581: entity_name := WSH_TRIP_STOPS_PVT.Get_Name(p_stop_ids(i));
582:

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

577: IF l_debug_on THEN
578: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
579: END IF;
580: --
581: entity_name := WSH_TRIP_STOPS_PVT.Get_Name(p_stop_ids(i));
582:
583: --bug 1633386
584: OPEN c_stop_trip_id_cursor( p_stop_ids(i));
585: LOOP