APPS.WSH_DELIVERY_LEGS_GRP dependencies on WSH_TRIP_STOPS

Line 812: wsh_new_deliveries d, wsh_delivery_legs l, wsh_trip_stops s

808: l_num_errors NUMBER;
809:
810: cursor c_is_final_leg (p_dleg_id in number) is
811: select d.delivery_id from
812: wsh_new_deliveries d, wsh_delivery_legs l, wsh_trip_stops s
813: where l.delivery_id = d.delivery_id
814: and d.ultimate_dropoff_location_id = s.stop_location_id
815: and l.drop_off_stop_id = s.stop_id
816: and l.delivery_leg_id = p_dleg_id;