APPS.WSH_FTE_COMP_CONSTRAINT_PKG dependencies on WSH_TRIP_STOPS

Line 22: p_stop_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,

18: p_action_code IN VARCHAR2,
19: p_del_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type ,
20: p_det_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
21: p_trip_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
22: p_stop_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
23: p_in_ids IN wsh_util_core.id_tab_type,
24: p_pickup_stop_id IN NUMBER DEFAULT NULL,
25: p_pickup_loc_id IN NUMBER DEFAULT NULL,
26: p_pickup_stop_seq IN NUMBER DEFAULT NULL,

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