---

SELECT
    o.id AS operation_id,
    o.operation_date
FROM back_office.eps_transaction et
JOIN ourpension.eps e
    ON e.id = et.eps_id
JOIN back_office.eps_transaction_source src
    ON src.id = et.eps_transaction_source_id
JOIN back_office.operation o
    ON o.id = src.operation_id
WHERE e.service_type = 'NPO'
  AND o.operation_date BETWEEN
          TO_DATE(:startDate, 'DD.MM.YYYY')
      AND TO_DATE(:endDate, 'DD.MM.YYYY')
LIMIT 1;