---

-- Проверяем статус документа 20
SELECT id, status_id, hb_pens_product_kind_code
FROM back_office.accrual_repurchase_amount_payments
WHERE id = 20;



-- Есть ли реестр выплат по документу 20?
SELECT p.payment_register_id, COUNT(*)
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 = 20
GROUP BY p.payment_register_id;