APPS.OKL_UPDT_CASH_DTLS dependencies on OKL_TRX_CSH_RECEIPT_B

Line 35: l_rcpt_amount OKL_TRX_CSH_RECEIPT_B.AMOUNT%TYPE DEFAULT NULL;

31: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
32:
33: l_conversion_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
34:
35: l_rcpt_amount OKL_TRX_CSH_RECEIPT_B.AMOUNT%TYPE DEFAULT NULL;
36: l_rcpt_currency_code OKL_TRX_CSH_RECEIPT_B.CURRENCY_CODE%TYPE DEFAULT NULL;
37: l_func_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;
38: l_func_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL;
39: l_total_amount_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE;

Line 36: l_rcpt_currency_code OKL_TRX_CSH_RECEIPT_B.CURRENCY_CODE%TYPE DEFAULT NULL;

32:
33: l_conversion_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
34:
35: l_rcpt_amount OKL_TRX_CSH_RECEIPT_B.AMOUNT%TYPE DEFAULT NULL;
36: l_rcpt_currency_code OKL_TRX_CSH_RECEIPT_B.CURRENCY_CODE%TYPE DEFAULT NULL;
37: l_func_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE DEFAULT NULL;
38: l_func_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL;
39: l_total_amount_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE;
40:

Line 132: FROM okl_trx_csh_receipt_b a,

128: -- get receipt info
129: CURSOR c_get_rcpt_info (cp_rct_id IN NUMBER) IS
130: SELECT a.currency_code, a.amount, -- rcpt currency
131: b.currency_code, b.remittance_amount -- functional currency
132: FROM okl_trx_csh_receipt_b a,
133: okl_ext_csh_rcpts_b b
134: WHERE a.id = cp_rct_id
135: AND a.id = b.rct_id;
136:

Line 175: DELETE FROM OKL_TRX_CSH_RECEIPT_B

171: FETCH c_get_strm_dtls INTO l_rct_id_details, l_cnr_id, l_khr_id;
172: CLOSE c_get_strm_dtls;
173:
174: -- clear up internal receipt
175: DELETE FROM OKL_TRX_CSH_RECEIPT_B
176: WHERE ID = l_rct_id_details;
177:
178: -- clear up internal receipt lines
179: DELETE FROM OKL_TXL_RCPT_APPS_B