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
Kronos获取累计池数量
最新推荐文章于 2024-09-14 21:52:32 发布