Třídová akce

Kód:

3

Tělo:

SELECT SUM(A.ABSENTTO$DATE - A.ABSENTFROM$DATE +1) AS DAYCOUNT
 FROM SickBenefits2 A
 JOIN SickBenefits B ON A.PARENT_ID = B.ID
 JOIN WagePeriods C ON A.WagePeriod_ID = C.ID
 WHERE A.WAGEPERIOD_ID = :WAGEPERIOD
  AND ((A.AbsentFrom$DATE<=C.DateTo$DATE) AND (A.AbsentTo$DATE>=C.DateFrom$DATE))
  AND A.ROWTYPE IN (1,3)
  AND B.WORKINGRELATION_ID = :WORKINGRELATION
  AND B.BASESICKTYPE IN ({SICKTYPE})
  AND {EXCLDAYS}
  AND {DELETEDINCLOSEDPERIOD}

Generated by ABRA Software a.s. 27.10.2021 16:34:36