APPS.OKL_TRANS_CONTRACTS_PVT dependencies on OKL_TRNS_ACC_DSTRS

Line 635: FROM OKL_TRNS_ACC_DSTRS

631: IS
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:

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';