APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on AR_CASH_RECEIPTS_ALL

Line 1111: FROM ar_cash_receipts_all

1107:
1108:
1109: CURSOR get_receipt_number(p_cash_receipt_id NUMBER) IS
1110: SELECT RECEIPT_NUMBER
1111: FROM ar_cash_receipts_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

Line 1231: l_rct_num ar_cash_receipts_all.receipt_number%TYPE;

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