APPS.GMI_UPDATE_ORDER dependencies on WSH_DELIVERY_LEGS

Line 43: FROM wsh_delivery_legs dg,

39: rcv_inter_req_submission exception;
40:
41: CURSOR pickup_deliveries (p_stop_id NUMBER)IS
42: SELECT dg.delivery_id , st.transaction_header_id
43: FROM wsh_delivery_legs dg,
44: wsh_new_deliveries dl,
45: wsh_trip_stops st
46: WHERE st.stop_id = dg.pick_up_stop_id AND
47: st.stop_id = p_stop_id AND