APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_DELIVERY_LEGS

Line 3290: FROM wsh_delivery_legs wdg, wsh_trip_stops wts

3286:
3287: -- cursors
3288: CURSOR del_trip_stops IS
3289: SELECT wdg.pick_up_stop_id, wdg.drop_off_stop_id, wts.trip_id
3290: FROM wsh_delivery_legs wdg, wsh_trip_stops wts
3291: WHERE wdg.delivery_id = p_delivery_id
3292: AND wdg.pick_up_stop_id = wts.stop_id;
3293:
3294: CURSOR int_del_trip_stops IS