2164: cursor Cselremit(CustomerTrxId NUMBER)
2165: IS SELECT
2166: customer_trx_id
2167: FROM 2168: ar_batches b , 2169: ar_payment_schedules p
2170: where p.customer_trx_id = CUSTOMERTRXID
2171: and p.reserved_type = 'REMITTANCE'
2172: and p.reserved_value=b.batch_id