APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 1046: FROM ra_customer_trx_all

1042: WHERE cash_receipt_id = p_cash_receipt_id;
1043:
1044: CURSOR cm_number ( p_app_trx_id NUMBER ) IS
1045: SELECT trx_number
1046: FROM ra_customer_trx_all
1047: WHERE customer_trx_id = p_app_trx_id;
1048:
1049: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1050: CURSOR total_bill_amt_csr ( p_tld_id NUMBER ) IS

Line 1162: l_trx_num ra_customer_trx_all.trx_number%TYPE;

1158:
1159: l_payout_date DATE;
1160:
1161: l_rct_num ar_cash_receipts_all.receipt_number%TYPE;
1162: l_trx_num ra_customer_trx_all.trx_number%TYPE;
1163:
1164: l_total_rcpt_amt NUMBER;
1165: l_total_bill_amt NUMBER;
1166: