APPS.WSH_FTE_COMP_CONSTRAINT_PKG dependencies on WSH_DELIVERY_LEGS

Line 111: from wsh_trip_stops wts, wsh_delivery_legs wdl

107: WHERE delivery_Id = l_delivery_id;
108:
109: cursor c_gettrip(l_deliveryid IN NUMBER) is
110: select wts.TRIP_ID
111: from wsh_trip_stops wts, wsh_delivery_legs wdl
112: where wdl.delivery_id =l_deliveryid AND
113: wdl.pick_up_stop_id = wts.stop_id;
114:
115: cursor c_getdeliverytype(l_deliveryid IN NUMBER) is

Line 829: FROM wsh_delivery_legs

825: WHERE trip_id = c_trip_id;
826:
827: CURSOR c_get_parent_delivery_leg(c_del_id NUMBER, c_del_leg_id NUMBER) IS
828: SELECT PARENT_DELIVERY_LEG_ID
829: FROM wsh_delivery_legs
830: WHERE DELIVERY_LEG_ID = c_del_leg_id
831: AND DELIVERY_ID = c_del_id;
832:
833: l_return_status VARCHAR2(1);