Třídová akce

Kód:

20

Tělo:

SELECT A.ABSENTTO$DATE, A.ABSENTFROM$DATE, B.FirstDay
 FROM SickBenefits2 A
 JOIN SickBenefits B ON A.PARENT_ID = B.ID
 JOIN WagePeriods C ON A.WagePeriod_ID = C.ID
 WHERE A.WAGEPERIOD_ID = :WAGEPERIOD
  AND ((A.AbsentFrom$DATE<=C.DateTo$DATE) AND (A.AbsentTo$DATE>=C.DateFrom$DATE))
  AND A.ROWTYPE IN (1,3)
  AND B.WORKINGRELATION_ID = :WORKINGRELATION
  AND B.BASESICKTYPE IN ({SICKTYPE})
  AND {EXCLDAYS}
  AND A.DELETEDINCLOSEDPERIOD <> 'A'

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