Třídová akce

Kód:

17

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.ABSENTFrom$DATE <> 0) and (A.ABSENTFrom$DATE BETWEEN :DATEFROM and :DATETO)) OR
  ((A.ABSENTTo$DATE <> 0) and (A.ABSENTTo$DATE BETWEEN :DATEFROM and :DATETO)) OR
  ((A.AbsentTo$DATE <> 0) and (A.AbsentFrom$DATE <> 0) and (A.AbsentFrom$DATE < :DATEFROM) and (A.AbsentTo$DATE > :DATETO))
  )
  AND B.BASESICKTYPE IN ({SICKTYPE})
  AND {EXCLDAYS}
  AND {DELETEDINCLOSEDPERIOD}

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