Třídová akce

Kód:

7

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
 LEFT JOIN WagePeriods WP ON WP.ID = :WagePeriod
 WHERE B.WorkingRelation_ID = :WorkingRelation
  AND A.ROWTYPE IN (1,2)
  AND (((A.PaidFrom$DATE <> 0) and (A.PaidFrom$DATE BETWEEN WP.DateFrom$DATE and WP.DateTo$Date)) OR ((A.PaidTo$DATE <> 0) and (A.PaidTo$DATE BETWEEN WP.DateFrom$DATE and WP.DateTo$Date)))
  AND B.BASESICKTYPE IN ({SICKTYPE})
  AND {EXCLDAYS}
  AND {DELETEDINCLOSEDPERIOD}
  

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