Třídová akce

Kód:

29

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
 JOIN WorkingInjuries WI ON WI.ID = B.WorkingInjury_ID 
 WHERE
  (((A.AbsentFrom$DATE <= :DateTo) AND (A.AbsentFrom$DATE>= :DateFrom)) or ((A.AbsentTo$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 (WI.BaseType IN ({WI_BaseType})) 
  AND (
        (:WI_Relevance = -1) OR
        ((:WI_Relevance <> -1) AND (WI.Relevance = :WI_Relevance))
      )          

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