Třídová akce

Kód:

8

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
:DateOf >= C.DateFrom$DATE AND (A.ValidTo_ID is null OR D.DateTo$DATE >= :DateOf) AND
(-1=:KindOf OR B.CountOffKind = :KindOf) and (B.TaxAdvantage = :TaxAdvantage)

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