APPS.GMI_UPDATE_ORDER dependencies on WSH_NEW_DELIVERIES

Line 44: wsh_new_deliveries dl,

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
48: st.stop_location_id = dl.initial_pickup_location_id AND