Třídová akce

Kód:

13

Tělo:

SELECT S.BaseSickType, S.ID, R.AbsentFrom$DATE, R.AbsentTo$DATE, S.DateFrom$DATE, S.DateTo$DATE
 FROM SickBenefits2 R
 JOIN SickBenefits S ON S.ID = R.Parent_ID
 WHERE S.WorkingRelation_ID = :WorkingRelationID AND
  S.BaseSickType in ({BaseSickTypes}) AND
  R.AbsentFrom$DATE <= :DateTo AND
  R.AbsentTo$DATE >= :DateFrom
  AND {DELETEDINCLOSEDPERIOD}
 ORDER BY S.ID, R.AbsentFrom$DATE

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