APPS.WSH_TRIP_CONSOLIDATION dependencies on WSH_TRIPS

Line 915: FROM wsh_trips wt, wsh_trip_stops wts1,

911: v_numCalls NUMBER;
912: --
913: CURSOR c_DeliveryCount(p_tripId IN NUMBER) IS
914: SELECT count(DISTINCT delivery_id)
915: FROM wsh_trips wt, wsh_trip_stops wts1,
916: wsh_trip_stops wts2, wsh_delivery_legs wdl
917: WHERE wt.trip_id = p_tripId
918: AND wts1.stop_id = wdl.pick_up_stop_id
919: AND wts2.stop_id = wdl.drop_off_stop_id

Line 990: WSH_TRIPS_ACTIONS.AutoCreate_Trip_multi(

986: v_TotalDelCount := 0;
987: v_numCalls := v_numCalls + 1;
988: SAVEPOINT Before_Autocreate_Trip;
989: --
990: WSH_TRIPS_ACTIONS.AutoCreate_Trip_multi(
991: p_del_rows => l_delivery_tab,
992: x_trip_ids => l_trip_tab,
993: x_trip_names => l_trip_name_tab,
994: x_return_status => l_return_status);