---

-- Ищем где создаются payment-записи для accrual_pension (аналог для пенсий)
SELECT routine_schema, routine_name
FROM information_schema.routines
WHERE routine_type IN ('PROCEDURE', 'FUNCTION')
  AND routine_schema = 'back_office'
  AND routine_definition ILIKE '%insert into back_office.payment%'
  AND routine_definition ILIKE '%accrual_pension%'
ORDER BY routine_name;



-- Найдем документ где payment уже есть (для выкупных сумм)
SELECT DISTINCT d.accrual_repurchase_amount_payments_id
FROM back_office.payment p
JOIN back_office.accrual_repurchase_amount_payments_details d 
  ON d.id = p.accrual_repurchase_id
LIMIT 5;