APPS.WSH_TRIP_CONSOLIDATION dependencies on WSH_TRIPS

Line 895: FROM wsh_trips wt, wsh_trip_stops wts1,

891: v_numCalls NUMBER;
892: --
893: CURSOR c_DeliveryCount(p_tripId IN NUMBER) IS
894: SELECT count(DISTINCT delivery_id)
895: FROM wsh_trips wt, wsh_trip_stops wts1,
896: wsh_trip_stops wts2, wsh_delivery_legs wdl
897: WHERE wt.trip_id = p_tripId
898: AND wts1.stop_id = wdl.pick_up_stop_id
899: AND wts2.stop_id = wdl.drop_off_stop_id

Line 970: WSH_TRIPS_ACTIONS.AutoCreate_Trip_multi(

966: v_TotalDelCount := 0;
967: v_numCalls := v_numCalls + 1;
968: SAVEPOINT Before_Autocreate_Trip;
969: --
970: WSH_TRIPS_ACTIONS.AutoCreate_Trip_multi(
971: p_del_rows => l_delivery_tab,
972: x_trip_ids => l_trip_tab,
973: x_trip_names => l_trip_name_tab,
974: x_return_status => l_return_status);