APPS.OKL_TRANS_CONTRACTS_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 21: FROM OKL_TXL_CNTRCT_LNS

17:
18: -- Cursor to fetch trx line amount
19: CURSOR txl_amt_csr (l_trx_id NUMBER) IS
20: SELECT SUM(AMOUNT) SUM_AMOUNT
21: FROM OKL_TXL_CNTRCT_LNS
22: WHERE TCN_ID = l_trx_id;
23:
24: l_sum_txl_amt NUMBER := 0;
25:

Line 636: WHERE source_id IN (SELECT id FROM OKL_TXL_CNTRCT_LNS

632:
633: CURSOR chk_csr(v_tcn_id NUMBER, v_source_table VARCHAR2) IS
634: SELECT NVL(COUNT(*),0)
635: FROM OKL_TRNS_ACC_DSTRS
636: WHERE source_id IN (SELECT id FROM OKL_TXL_CNTRCT_LNS
637: WHERE TCN_ID = v_tcn_id)
638: AND source_table = v_source_table;
639:
640:

Line 643: FROM OKL_TXL_CNTRCT_LNS

639:
640:
641: CURSOR tcl_csr(v_tcn_id NUMBER) IS
642: SELECT ID
643: FROM OKL_TXL_CNTRCT_LNS
644: WHERE TCN_ID = v_tcn_id;
645:
646:
647: CURSOR tcn_csr(v_tcn_id NUMBER) IS

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

652:
653: tcl_rec tcl_csr%ROWTYPE;
654: l_source_id_tbl OKL_REVERSAL_PUB.SOURCE_ID_TBL_TYPE;
655: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;
656: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';
657: l_acct_date DATE := SYSDATE;
658:
659: l_total_dist NUMBER := 0;
660: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TRX_CONTRACTS';