Třídová akce

Kód:

5

Tělo:

SELECT SUM(A.TOTALABSENTHOURS) AS ABSENTHOURS
 FROM SickBenefits2 A, SickBenefits B
 WHERE A.PARENT_ID = B.ID AND A.WAGEPERIOD_ID = :WAGEPERIOD
  AND A.ROWTYPE IN (1,3)
  AND B.WORKINGRELATION_ID = :WORKINGRELATION
  AND B.BASESICKTYPE IN ({SICKTYPE})
  AND {EXCLDAYS}
  AND {DELETEDINCLOSEDPERIOD}

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