APPS.OKL_ACCOUNT_DIST_MISC_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 37: FROM OKL_TXL_CNTRCT_LNS

33: currency_conversion_rate,
34: currency_conversion_type
35: FROM OKL_TRX_CONTRACTS
36: WHERE ID IN (SELECT TCN_ID
37: FROM OKL_TXL_CNTRCT_LNS
38: WHERE ID = v_source_id);
39:
40: BEGIN
41:

Line 313: l_line_amount OKL_TXL_CNTRCT_LNS.AMOUNT%TYPE;

309: IS
310:
311: l_total_cr_amount NUMBER := 0;
312: l_total_dr_amount NUMBER := 0;
313: l_line_amount OKL_TXL_CNTRCT_LNS.AMOUNT%TYPE;
314: i NUMBER := 0;
315:
316: CURSOR lineAmount_csr(v_source_id NUMBER) IS
317: SELECT amount

Line 318: FROM OKL_TXL_CNTRCT_LNS

314: i NUMBER := 0;
315:
316: CURSOR lineAmount_csr(v_source_id NUMBER) IS
317: SELECT amount
318: FROM OKL_TXL_CNTRCT_LNS
319: WHERE ID = v_source_id;
320:
321: BEGIN
322:

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

378: l_tabv_rec_out TABV_REC_TYPE;
379: l_tabv_rec TABV_REC_TYPE;
380: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
381: l_check_status NUMBER;
382: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';
383:
384: -- Added by Santonyr to fix the bug 3089327 on 07th Aug, 2003
385:
386: l_tcn_id OKL_TRX_CONTRACTS.ID%TYPE;

Line 391: FROM OKL_TXL_CNTRCT_LNS

387: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;
388:
389: CURSOR tcl_csr(v_source_id NUMBER) IS
390: SELECT tcn_id
391: FROM OKL_TXL_CNTRCT_LNS
392: WHERE ID = v_source_id;
393:
394: CURSOR tcn_csr(v_tcn_id NUMBER) IS
395: SELECT tsu_code