Třídová akce

Kód:

24

Tělo:

SELECT SUM(A.CompensationBoost) AS TOTALCOMPBOOST
 FROM SickBenefits2 A, SickBenefits B
 WHERE A.PARENT_ID = B.ID AND A.WAGEPERIOD_ID = :WAGEPERIOD
  AND A.ROWTYPE IN (1,2)
  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