SELECT A.ID FROM WageListCommon A
JOIN WagePeriods WP ON A.WagePeriod_ID = WP.ID
WHERE ((A.Employee_ID = :EmployeeID) or (:EmployeeID = '0000000000')) AND
IB_DecodeDate_Year(WP.DateFrom$DATE) = :YearNumberGenerated by ABRA Software a.s. 27.10.2021 16:34:36