Třídová akce

Kód:

23

Tělo:

SELECT A.PAIDTO$DATE, A.PAIDFROM$DATE, B.FirstDay, A.ID, B.LastDay, B.PayWorkingDays
 FROM SickBenefits2 A
 JOIN SickBenefits B ON A.PARENT_ID = B.ID
 WHERE
  (((A.PaidFrom$DATE <= :DateTo) AND (A.PaidFrom$DATE>= :DateFrom)) or ((A.PaidTo$DATE <= :DateTo) AND (A.PaidTo$DATE>= :DateFrom)))
  AND A.ROWTYPE IN (1,2)
  AND B.WORKINGRELATION_ID = :WORKINGRELATION
  AND B.BASESICKTYPE IN ({SICKTYPE})
  AND {EXCLDAYS}
  AND A.DELETEDINCLOSEDPERIOD <> 'A'

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