---

-- Смотрим как заполнен payment для существующего документа выкупных сумм
SELECT 
    p.payment_register_id,
    p.sharer_id,
    p.accrual_repurchase_id,
    p.topay,
    p.total_topay,
    p.payment_way,
    p.outgoing_order_number,
    p.completed,
    p.operation_id
FROM back_office.payment p
JOIN back_office.accrual_repurchase_amount_payments_details d 
  ON d.id = p.accrual_repurchase_id
WHERE d.accrual_repurchase_amount_payments_id = 176
LIMIT 10;



-- Полное тело create_bank_payment
SELECT prosrc 
FROM pg_proc p
JOIN pg_namespace n ON p.pronamespace = n.oid
WHERE n.nspname = 'back_office'
  AND p.proname = 'create_bank_payment';