SELECT {FIELDS}
FROM InsurancePeriodDetails A
LEFT JOIN InsurancePeriods IP ON A.Parent_ID = IP.ID
LEFT JOIN WorkingRelations WR ON IP.Parent_ID = WR.ID
WHERE
WR.Employee_ID = :EMPLOYEE AND
A.WagePeriod_ID = :WAGEPERIOD AND
IP.InsuranceBaseType = :INSTYPE Generated by ABRA Software a.s. 27.10.2021 16:34:36