Kronos获取累计池数量

SELECT SUM(ACCRUALTRAN.AMOUNT) 
FROM ACCRUALTRAN 
WHERE 	(
			ACCRUALTRAN.ACCRUALCODEID=@accrualcodeid 
			AND ACCRUALTRAN.EFFECTIVEDATE <=@enddate
			AND (ACCRUALTRAN.EFFECTIVEDATE>=
					(SELECT MAX(ATRN.EFFECTIVEDATE) 
					FROM ACCRUALTRAN ATRN
					WHERE ATRN.EFFECTIVEDATE<=@enddate 
					AND ATRN.ACCRUALCODEID=@accrualcodeid 
					AND ATRN.TYPE IN (3,11)
					AND ATRN.PERSONID=@employeeid)
				)
			AND NOT EXISTS (
							SELECT N'X' 
							FROM ACCRUALTRAN AT3 
							WHERE AT3.PERSONID=@employeeid 
							AND AT3.ACCRUALCODEID=ACCRUALTRAN.ACCRUALCODEID 
							AND AT3.EFFECTIVEDATE=ACCRUALTRAN.EFFECTIVEDATE 
							AND AT3.TYPE=3 AND ACCRUALTRAN.TYPE=11
							) 
			AND (ACCRUALTRAN.SUSPENDED_SW=0 OR ACCRUALTRAN.SUSPENDED_SW IS NULL) 
			AND (ACCRUALTRAN.EXCLUDED_SW=0 OR ACCRUALTRAN.EXCLUDED_SW IS NULL) 
			AND (ACCRUALTRAN.DISQUALIFIED_SW=0 OR ACCRUALTRAN.DISQUALIFIED_SW IS NULL) 
			AND (ACCRUALTRAN.SPCEDEDBYRESET_SW=0 OR ACCRUALTRAN.SPCEDEDBYRESET_SW IS NULL)
		) 
AND ACCRUALTRAN.PERSONID=@employeeid GROUP BY ACCRUALTRAN.PERSONID