Třídová akce

Kód:

9

Tělo:

SELECT E.ID from FamilyMembers E
LEFT JOIN CountOffTypes F ON E.CountOffType_ID = F.ID
LEFT JOIN WagePeriods G ON E.ValidFrom_ID = G.ID
LEFT JOIN WagePeriods H ON E.ValidTo_ID = H.ID
WHERE E.Parent_ID = :OBJID AND
:DateOf >= G.DateFrom$DATE AND (E.ValidTo_ID is null OR H.DateTo$DATE >= :DateOf) AND
(-1=:KindOf OR F.CountOffKind = :KindOf) and (F.TaxAdvantage = :TaxAdvantage)

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