Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/RecyclingApplicationManagerImpl.java
===================================================================
diff -u -r40614 -r40810
--- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/RecyclingApplicationManagerImpl.java	(.../RecyclingApplicationManagerImpl.java)	(revision 40614)
+++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/RecyclingApplicationManagerImpl.java	(.../RecyclingApplicationManagerImpl.java)	(revision 40810)
@@ -4555,7 +4555,7 @@
 		}
 		String tdSql = taskGroupsSql + tousseGroupIdsSql;
 		if(StringUtils.isNotBlank(tdSql)){
-			tdSql = " po.tousseDefinitionId in(select id from TousseDefinition where 1=1 "+ tdSql +")";
+			tdSql = " and exists ( select 1 from TousseDefinition tddd where po.tousseDefinitionId=tddd.id "+ tdSql +")";
 		}
 		String orgUnitCodingSql = "";
 		if(StringUtils.isNotBlank(recyDepartmentGroupDepartCodes)){