APPS.WSH_XC_UTIL dependencies on WSH_DELIVERY_LEGS

Line 3970: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st

3966: -- This is the same cursor as in close_exceptions.
3967: CURSOR Get_Deliveries_Stop(v_stop_id NUMBER) IS
3968: -- pick up deliveries
3969: SELECT dg.delivery_id
3970: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
3971: WHERE dg.delivery_id = dl.delivery_id
3972: AND st.stop_location_id = dl.initial_pickup_location_id
3973: AND st.stop_id = dg.pick_up_stop_id
3974: AND st.stop_id = v_stop_id

Line 3978: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st

3974: AND st.stop_id = v_stop_id
3975: UNION ALL
3976: -- drop off deliveries
3977: SELECT dg.delivery_id
3978: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
3979: WHERE dg.delivery_id = dl.delivery_id
3980: AND st.stop_location_id = dl.ultimate_dropoff_location_id
3981: AND st.stop_id = dg.drop_off_stop_id
3982: AND st.stop_id = v_stop_id;

Line 4445: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st

4441: -- This is the same cursor as in check_exceptions.
4442: CURSOR Get_Deliveries_Stop(v_stop_id NUMBER) IS
4443: -- pick up deliveries
4444: SELECT dg.delivery_id
4445: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
4446: WHERE dg.delivery_id = dl.delivery_id
4447: AND st.stop_location_id = dl.initial_pickup_location_id
4448: AND st.stop_id = dg.pick_up_stop_id
4449: AND st.stop_id = v_stop_id

Line 4453: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st

4449: AND st.stop_id = v_stop_id
4450: UNION ALL
4451: -- drop off deliveries
4452: SELECT dg.delivery_id
4453: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
4454: WHERE dg.delivery_id = dl.delivery_id
4455: AND st.stop_location_id = dl.ultimate_dropoff_location_id
4456: AND st.stop_id = dg.drop_off_stop_id
4457: AND st.stop_id = v_stop_id;