PAY - EJV - REFUND_REQUESTED transactions that can be stuck

[seeker25]

Investigate into transactions that are REFUND_REQUESTED for EJV that are stuck.

[Jxio]

SELECT i.paid, i.refund, i.disbursement_status_code
FROM invoices i 
WHERE i.payment_method_code = 'EJV'
  AND i.invoice_status_code = 'REFUND_REQUESTED'
  AND i.created_on < NOW() - INTERVAL '20 DAY';
  and i.paid != i.refund;

31 EJV invoices stuck at REFUND_REQUESTED, 30 of them paid = refund, but no disbursement status, so it was ignored by payment-jobs. 1 invoice shows paid = 0, but refund = 10

[seeker25]

These invoices were from SBC_STAFF org, we need a code change to set the invoices to REFUNDED if they are billable = 'f'