Třídová akce

Kód:

11

Tělo:

SELECT A.ID
 FROM SickBenefits A
 JOIN WorkingRelations B ON A.WorkingRelation_ID=B.ID
 WHERE B.Employee_ID=:EmployeeID AND
  (
   (DATEFROM$DATE<=:DATETO AND (DATETO$DATE=0 OR 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
  )

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