Třídová akce

Kód:

6

Tělo:

SELECT {FIELDS} FROM WorkingRelations A
 JOIN EmployPatterns B ON A.EmployPattern_ID = B.ID
 JOIN WagePeriods WP ON WP.ID = :WAGEPERIOD_ID
 WHERE
  A.Employee_ID = :OBJID AND
  A.DateOfBegin$DATE <= :VALIDTO AND (A.DateOfEnd$Date = 0 OR A.DateOfEnd$DATE >= :VALIDFROM) AND
  A.Hidden = 'N' and
  ((A.DateOfChangeEdit = 0) or (A.DateOfChangeEdit <= WP.DateFrom$DATE))
 ORDER BY
  A.DateOfBegin$DATE, A.ID

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