Třídová akce

Kód:

14

Tělo:

SELECT {FIELDS}
 FROM SickBenefits2 A
 JOIN SickBenefits B ON B.ID = A.Parent_ID
 JOIN WorkingRelations W ON W.ID = B.WorkingRelation_ID
 WHERE B.WorkingRelation_ID = :WorkingRelation
  AND A.ROWTYPE IN (1,2)
  AND A.WagePeriod_ID = :WagePeriod
  AND B.BASESICKTYPE IN ({SICKTYPE})
  AND {EXCLDAYS}
  AND {DELETEDINCLOSEDPERIOD}

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