Třídová akce

Kód:

6

Tělo:

SELECT A.ID
 FROM SickBenefits A
 WHERE
  (A.WORKINGRELATION_ID=:WORKINGRELATION OR '0000000000'=:WORKINGRELATION)
  AND
  (
  (A.DATEFROM$DATE<=:DATETO AND (A.DATETO$DATE=0 OR A.DATETO$DATE>=:DATEFROM))
  OR
  (SELECT Count(*) FROM SickBenefits2 SB2 WHERE A.ID=SB2.Parent_ID AND SB2.WagePeriod_ID=:WAGEPERIOD AND SB2.RowType IN (1,2,4) AND SB2.DeletedInClosedPeriod<>'A')>0
  )
ORDER BY A.DATEFROM$DATE

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