Třídová akce

Kód:

12

Tělo:

SELECT S.BaseSickType, S.ID, R.PaidFrom$DATE, R.PaidTo$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.PaidFrom$DATE <= :DateTo AND
  R.PaidTo$DATE >= :DateFrom
  AND {DELETEDINCLOSEDPERIOD}
 ORDER BY S.ID, R.PaidFrom$DATE

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