APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on AR_CASH_RECEIPTS_ALL

Line 1041: FROM ar_cash_receipts_all

1037: --end:| 25-Jun-2008 cklee Fixed bug: 6784252 |
1038:
1039: CURSOR get_receipt_number(p_cash_receipt_id NUMBER) IS
1040: SELECT RECEIPT_NUMBER
1041: FROM ar_cash_receipts_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

Line 1161: l_rct_num ar_cash_receipts_all.receipt_number%TYPE;

1157: l_pdt_id okl_products_v.id%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;