APPS.OKL_MISC_TRANS_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 246: FROM OKL_TXL_CNTRCT_LNS

242:
243: -- Cursor to fetch trx line amount
244: CURSOR txl_amt_in_csr (l_trx_id NUMBER) IS
245: SELECT SUM(AMOUNT) SUM_AMOUNT
246: FROM OKL_TXL_CNTRCT_LNS
247: WHERE TCN_ID = l_trx_id;
248:
249: -- Cursor to fetch trx line amount
250: CURSOR txl_amt_up_csr (l_trx_id NUMBER, l_txl_id NUMBER) IS

Line 252: FROM OKL_TXL_CNTRCT_LNS

248:
249: -- Cursor to fetch trx line amount
250: CURSOR txl_amt_up_csr (l_trx_id NUMBER, l_txl_id NUMBER) IS
251: SELECT SUM(AMOUNT) SUM_AMOUNT
252: FROM OKL_TXL_CNTRCT_LNS
253: WHERE TCN_ID = l_trx_id AND
254: ID <> l_txl_id;
255:
256:

Line 315: FROM OKL_TXL_CNTRCT_LNS

311: SELECT avl_id,
312: sty_id,
313: description,
314: amount
315: FROM OKL_TXL_CNTRCT_LNS
316: WHERE ID = v_tcl_id;
317:
318:
319: l_api_name CONSTANT VARCHAR2(40) := 'CREATE_MISC_DSTR_LINE';

Line 332: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';

328: l_tclv_rec_in TCLV_REC_TYPE ;
329: l_tclv_rec_out TCLV_REC_TYPE;
330: l_tabv_tbl OKL_TRNS_ACC_DSTRS_PUB.TABV_TBL_TYPE;
331: l_old_avl_id NUMBER := NULL;
332: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';
333: i NUMBER := 0;
334: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;
335:
336: l_check_status NUMBER;

Line 339: l_description OKL_TXL_CNTRCT_LNS.DESCRIPTION%TYPE;

335:
336: l_check_status NUMBER;
337: l_avl_id NUMBER;
338: l_sty_id NUMBER;
339: l_description OKL_TXL_CNTRCT_LNS.DESCRIPTION%TYPE;
340: l_amount NUMBER;
341:
342:
343:

Line 702: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';

698:
699: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
700:
701: l_template_name OKL_AE_TEMPLATES.NAME%TYPE;
702: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';
703: l_accounting_date DATE;
704:
705: -- Added by Santonyr on 22-Nov-2002 Multi-Currency
706: l_currency_code okl_trx_contracts.currency_code%TYPE;