APPS.FTE_WSH_INTERFACE_PKG dependencies on WSH_DELIVERY_LEGS

Line 1176: wsh_delivery_legs dg,

1172: CURSOR pickup_deliveries_cur (p_stop_id NUMBER) IS
1173: SELECT
1174: dg.delivery_id, dl.name
1175: FROM wsh_new_deliveries dl,
1176: wsh_delivery_legs dg,
1177: wsh_trip_stops st
1178: WHERE dg.delivery_id = dl.delivery_id
1179: AND st.stop_location_id = dl.initial_pickup_location_id
1180: AND st.stop_id = dg.pick_up_stop_id