APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 1116: FROM ra_customer_trx_all

1112: WHERE cash_receipt_id = p_cash_receipt_id;
1113:
1114: CURSOR cm_number ( p_app_trx_id NUMBER ) IS
1115: SELECT trx_number
1116: FROM ra_customer_trx_all
1117: WHERE customer_trx_id = p_app_trx_id;
1118:
1119: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1120: CURSOR total_bill_amt_csr ( p_tld_id NUMBER ) IS

Line 1232: l_trx_num ra_customer_trx_all.trx_number%TYPE;

1228:
1229: l_payout_date DATE;
1230:
1231: l_rct_num ar_cash_receipts_all.receipt_number%TYPE;
1232: l_trx_num ra_customer_trx_all.trx_number%TYPE;
1233:
1234: l_total_rcpt_amt NUMBER;
1235: l_total_bill_amt NUMBER;
1236: