---

-- Есть ли payment-записи для документа 531?
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 = 531
GROUP BY p.payment_register_id;




-- Есть ли payment-записи для принятого документа 533?
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 = 533
GROUP BY p.payment_register_id;