APPS.GMI_UPDATE_ORDER dependencies on WSH_TRIP_STOPS

Line 45: wsh_trip_stops st

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
49: dg.delivery_id = dl.delivery_id ;

Line 92: SELECT * FROM WSH_TRIP_STOPS

88: del_rec_stop_id pickup_deliveries%ROWTYPE;
89:
90:
91: CURSOR c_trip_stop (c_trip_stop_id NUMBER ) IS
92: SELECT * FROM WSH_TRIP_STOPS
93: WHERE STOP_ID = c_trip_stop_id;
94:
95: l_trip_stop_rec c_trip_stop%ROWTYPE;
96: