APPS.OKL_CREATE_KLE_PVT dependencies on OKL_TRX_CONTRACTS

Line 556: FROM okl_trx_contracts

552: WHERE cle.id = p_cle_id;
553:
554: CURSOR c_get_trx_date_trans_occ(p_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
555: SELECT date_transaction_occurred
556: FROM okl_trx_contracts
557: WHERE khr_id = p_chr_id
558: AND tcn_type = 'TRBK'
559: AND tsu_code = 'ENTERED'
560: --rkuttiya added for 12.1.1 Multi GAAP

Line 790: FROM okl_trx_contracts

786: WHERE cle.id = p_cle_id;
787:
788: CURSOR c_get_trx_date_trans_occ(p_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
789: SELECT date_transaction_occurred
790: FROM okl_trx_contracts
791: WHERE khr_id = p_chr_id
792: AND tcn_type = 'TRBK'
793: AND tsu_code = 'ENTERED'
794: --rkuttiya added for 12.1.1 Multi GAAP

Line 4752: okl_trx_contracts ktrx

4748:
4749: CURSOR l_chk_rbk_csr(p_chr_id IN NUMBER) is
4750: SELECT '!'
4751: FROM okc_k_headers_b CHR,
4752: okl_trx_contracts ktrx
4753: WHERE ktrx.khr_id_new = chr.id
4754: AND ktrx.tsu_code = 'ENTERED'
4755: AND ktrx.rbr_code is NOT NULL
4756: AND ktrx.tcn_type = 'TRBK'

Line 8693: okl_trx_contracts ktrx

8689: --Bug# 8652738
8690: CURSOR l_chk_rbk_csr(p_chr_id IN NUMBER) is
8691: SELECT '!'
8692: FROM okc_k_headers_b CHR,
8693: okl_trx_contracts ktrx
8694: WHERE ktrx.khr_id_new = chr.id
8695: AND ktrx.tsu_code = 'ENTERED'
8696: AND ktrx.rbr_code is NOT NULL
8697: AND ktrx.tcn_type = 'TRBK'

Line 14642: okl_trx_contracts ktrx

14638: --cursor to check if the contract is undergoing on-line rebook
14639: CURSOR l_chk_rbk_csr(p_chr_id IN NUMBER) is
14640: SELECT '!'
14641: FROM okc_k_headers_b chr,
14642: okl_trx_contracts ktrx
14643: WHERE ktrx.khr_id_new = chr.id
14644: AND ktrx.tsu_code = 'ENTERED'
14645: AND ktrx.rbr_code is NOT NULL
14646: AND ktrx.tcn_type = 'TRBK'

Line 16505: okl_trx_contracts ktrx

16501: --cursor to check if the contract is undergoing on-line rebook
16502: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
16503: SELECT '!'
16504: FROM okc_k_headers_b CHR,
16505: okl_trx_contracts ktrx
16506: WHERE ktrx.khr_id_new = chr.id
16507: AND ktrx.tsu_code = 'ENTERED'
16508: AND ktrx.rbr_code is NOT NULL
16509: AND ktrx.tcn_type = 'TRBK'

Line 18222: okl_trx_contracts ktrx

18218: --cursor to check if the contract is undergoing on-line rebook
18219: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
18220: SELECT '!'
18221: FROM okc_k_headers_b chr,
18222: okl_trx_contracts ktrx
18223: WHERE ktrx.khr_id_new = chr.id
18224: AND ktrx.tsu_code = 'ENTERED'
18225: AND ktrx.rbr_code is NOT NULL
18226: AND ktrx.tcn_type = 'TRBK'

Line 19266: okl_trx_contracts ktrx

19262: --cursor to check if the contract is undergoing on-line rebook
19263: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
19264: SELECT '!'
19265: FROM okc_k_headers_b chr,
19266: okl_trx_contracts ktrx
19267: WHERE ktrx.khr_id_new = chr.id
19268: AND ktrx.tsu_code = 'ENTERED'
19269: AND ktrx.rbr_code is NOT NULL
19270: AND ktrx.tcn_type = 'TRBK'

Line 20173: okl_trx_contracts ktrx

20169: --cursor to check if the contract is undergoing on-line rebook
20170: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
20171: SELECT '!'
20172: FROM okc_k_headers_b chr,
20173: okl_trx_contracts ktrx
20174: WHERE ktrx.khr_id_new = chr.id
20175: AND ktrx.tsu_code = 'ENTERED'
20176: AND ktrx.rbr_code is NOT NULL
20177: AND ktrx.tcn_type = 'TRBK'