APPS.WSH_TRIPS_PVT dependencies on WSH_FREIGHT_COSTS

Line 581: DELETE FROM wsh_freight_costs

577: END IF;
578:
579: END IF;
580:
581: DELETE FROM wsh_freight_costs
582: WHERE trip_id = l_trip_id;
583:
584: open get_trip_stops(l_trip_id);
585: loop

Line 589: DELETE FROM wsh_freight_costs WHERE stop_id = l_stop_id;

585: loop
586: fetch get_trip_stops into l_stop_id;
587: l_stop_tab(l_stop_tab.count+1) := l_stop_id; -- DBI project
588: exit when get_trip_stops%NOTFOUND ;
589: DELETE FROM wsh_freight_costs WHERE stop_id = l_stop_id;
590: end loop;
591: close get_trip_stops;
592:
593: DELETE FROM wsh_trip_stops