APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_DELIVERY_LEGS

Line 4374: FROM wsh_delivery_legs wdg, wsh_trip_stops wts

4370:
4371: -- cursors
4372: CURSOR del_trip_stops IS
4373: SELECT wdg.pick_up_stop_id, wdg.drop_off_stop_id, wts.trip_id
4374: FROM wsh_delivery_legs wdg, wsh_trip_stops wts
4375: WHERE wdg.delivery_id = p_delivery_id
4376: AND wdg.pick_up_stop_id = wts.stop_id;
4377:
4378: CURSOR int_del_trip_stops IS