Třídová akce

Kód:

16

Tělo:

SELECT {FIELDS}
 FROM SickBenefits2 A
 JOIN SickBenefits B ON B.ID = A.Parent_ID
 JOIN WorkingRelations W ON W.ID = B.WorkingRelation_ID
 WHERE B.WorkingRelation_ID = :WorkingRelation
  AND A.ROWTYPE IN (1,3)
  AND
  ( 
    (A.AbsentTo$DATE >= :DateFrom) AND
    (A.AbsentFrom$DATE <= :DateTo)
  )  
  AND B.BASESICKTYPE IN ({SICKTYPE})
  AND {EXCLDAYS}
  AND {DELETEDINCLOSEDPERIOD}

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