---

UPDATE report.conf_scheduler_sfr
SET is_active = true
WHERE id = 40
RETURNING id, name, is_active;


SELECT DISTINCT ON (c.id)
    c.id AS contract_id,
    c.number AS contract_number,
    atc.id AS application_id,
    atc.date AS original_date,
    current_date - 1 AS test_date
FROM ourpension.contract c
JOIN ourpension.sharer sh
    ON sh.contract_id = c.id
JOIN ourpension.application_termination_contract atc
    ON atc.sharer_id = sh.id
WHERE c.id IN (13687807, 13644952, 13687399)
  AND NOT EXISTS (
      SELECT 1
      FROM ourpension.year_tax_deduction td
      WHERE td.application_termination_contract_id = atc.id
        AND td.type IN ('RECEIVED', 'NOT_RECEIVED')
  )
ORDER BY c.id, atc.date DESC, atc.id DESC;