Třídová akce

Kód:

30

Tělo:

SELECT A.ID
FROM SickBenefits A
WHERE
(A.DATEFROM$DATE<=:DATEFROM
  AND ((A.DATETO$DATE=0) OR (A.DATETO$DATE>=:DATEFROM)
  OR (Exists(SELECT ID FROM Sickbenefits2 B WHERE B.RowType=1 AND B.Parent_ID=A.ID AND B.WagePeriod_ID = :WagePeriodID))))
AND (A.BaseSickType = :SICKTYPE) 
AND (A.WorkingRelation_ID = :WORKINGRELATION)

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