Třídová akce

Kód:

4

Tělo:

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