Objektová akce

Kód:

5

Tělo:

SELECT A.ID FROM CountOffDefinitions A
 JOIN CountOffTypes B ON A.CountOffType_ID = B.ID
 JOIN WagePeriods C ON A.ValidFrom_ID = C.ID
 LEFT JOIN WagePeriods D ON A.ValidTo_ID = D.ID
 WHERE A.Parent_ID = :OBJID AND B.Code = :Code
   AND (:DateFrom >= C.DateFrom$DATE)
   AND ((D.DateTo$DATE is null) OR (D.DateTo$DATE >= :DateFrom))

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