APPS.WSH_TRIPS_PVT dependencies on WSH_NEW_DELIVERIES

Line 727: FROM wsh_new_deliveries wnd, wsh_trip_stops wts, wsh_delivery_legs wdl

723: l_rowid VARCHAR2(30);
724:
725: CURSOR c_iscarriersmcchanged IS
726: SELECT wnd.organization_id, wnd.name
727: FROM wsh_new_deliveries wnd, wsh_trip_stops wts, wsh_delivery_legs wdl
728: WHERE wnd.delivery_id=wdl.delivery_id
729: and wdl.pick_up_stop_id=wts.stop_id
730: and wts.trip_id = p_trip_info.trip_id
731: and (carrier_id <> p_trip_info.carrier_id