Objektová akce

Kód:

1

Tělo:

SELECT A.ID
FROM RetirementReports A
WHERE
(A.WorkingRelation_ID = :WR) and (A.CalendarYear = :CY) and (A.ID <> :OBJID) and (A.Corrective = 'N') and
(
  ( 
    (A.PartOfYear = :PartOfYear) and
    (A.PartDateFrom$DATE = :PartDateFrom) and
    (A.PartDateTo$DATE = :PartDateTo)
  ) or
  (
    (A.PartOfYear = 'N') and 
    (:PartOfYear = 'A') and 
    (ib_DecodeDate_Month(:PartDateFrom) = 1) and
    (ib_DecodeDate_Month(:PartDateTo) = 12) 
  ) or
  (
    (A.PartOfYear = 'A') and
    (ib_DecodeDate_Month(A.PartDateFrom$DATE) = 1) and
    (ib_DecodeDate_Month(A.PartDateTo$DATE) = 12) and
    (:PartOfYear = 'N') 
  )
)   

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