Třídová akce

Kód:

21

Tělo:

SELECT {FIELDS}
 FROM SickBenefits2 A
 JOIN SickBenefits B ON A.PARENT_ID = B.ID
 JOIN WorkingRelations WR on WR.ID = B.WorkingRelation_ID
 JOIN Employees EMP ON EMP.ID = WR.Employee_ID 
 WHERE
  (
  ((A.AbsentFrom$DATE <= :DateTo) AND (A.AbsentFrom$DATE >= :DateFrom)) OR 
  ((A.AbsentTo$DATE <= :DateTo) AND (A.AbsentTo$DATE >= :DateFrom)) OR
  ((A.AbsentFrom$DATE < :DateTo) AND (A.AbsentTo$DATE > :DateFrom))
  )
  AND A.ROWTYPE IN (1,3)
  AND (
        ((:ALLWR = 'N') AND (B.WORKINGRELATION_ID = :WORKINGRELATION)) OR
        (:ALLWR = 'A')
      )  
  AND B.BASESICKTYPE IN ({SICKTYPE})
  AND {EXCLDAYS}
  AND A.DELETEDINCLOSEDPERIOD <> 'A'
  AND (
      (:WithWI = -1) OR
      ((:WithWI = 0) AND (B.WorkingInjury_ID is null or (B.WorkingInjury_ID = '0000000000'))) OR
      ((:WithWI = 1) AND (B.WorkingInjury_ID is not null or (B.WorkingInjury_ID <> '0000000000')))
      )  

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