290:
291: CURSOR c_trx_num IS
292: SELECT t.customer_trx_id
293: FROM ra_customer_trx t
294: ,ra_batch_sources bs
295: WHERE t.batch_source_id = bs.batch_source_id
296: AND t.trx_number = p_rev_adj_rec.trx_number
297: AND bs.name = NVL(p_rev_adj_rec.batch_source_name,bs.name)
298: AND NVL(t.invoicing_rule_id,0) <> -3