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 4711: okl_trx_contracts ktrx

4707:
4708: CURSOR l_chk_rbk_csr(p_chr_id IN NUMBER) is
4709: SELECT '!'
4710: FROM okc_k_headers_b CHR,
4711: okl_trx_contracts ktrx
4712: WHERE ktrx.khr_id_new = chr.id
4713: AND ktrx.tsu_code = 'ENTERED'
4714: AND ktrx.rbr_code is NOT NULL
4715: AND ktrx.tcn_type = 'TRBK'

Line 14536: okl_trx_contracts ktrx

14532: --cursor to check if the contract is undergoing on-line rebook
14533: CURSOR l_chk_rbk_csr(p_chr_id IN NUMBER) is
14534: SELECT '!'
14535: FROM okc_k_headers_b chr,
14536: okl_trx_contracts ktrx
14537: WHERE ktrx.khr_id_new = chr.id
14538: AND ktrx.tsu_code = 'ENTERED'
14539: AND ktrx.rbr_code is NOT NULL
14540: AND ktrx.tcn_type = 'TRBK'

Line 16343: okl_trx_contracts ktrx

16339: --cursor to check if the contract is undergoing on-line rebook
16340: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
16341: SELECT '!'
16342: FROM okc_k_headers_b CHR,
16343: okl_trx_contracts ktrx
16344: WHERE ktrx.khr_id_new = chr.id
16345: AND ktrx.tsu_code = 'ENTERED'
16346: AND ktrx.rbr_code is NOT NULL
16347: AND ktrx.tcn_type = 'TRBK'

Line 17997: okl_trx_contracts ktrx

17993: --cursor to check if the contract is undergoing on-line rebook
17994: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
17995: SELECT '!'
17996: FROM okc_k_headers_b chr,
17997: okl_trx_contracts ktrx
17998: WHERE ktrx.khr_id_new = chr.id
17999: AND ktrx.tsu_code = 'ENTERED'
18000: AND ktrx.rbr_code is NOT NULL
18001: AND ktrx.tcn_type = 'TRBK'

Line 19017: okl_trx_contracts ktrx

19013: --cursor to check if the contract is undergoing on-line rebook
19014: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
19015: SELECT '!'
19016: FROM okc_k_headers_b chr,
19017: okl_trx_contracts ktrx
19018: WHERE ktrx.khr_id_new = chr.id
19019: AND ktrx.tsu_code = 'ENTERED'
19020: AND ktrx.rbr_code is NOT NULL
19021: AND ktrx.tcn_type = 'TRBK'

Line 19898: okl_trx_contracts ktrx

19894: --cursor to check if the contract is undergoing on-line rebook
19895: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
19896: SELECT '!'
19897: FROM okc_k_headers_b chr,
19898: okl_trx_contracts ktrx
19899: WHERE ktrx.khr_id_new = chr.id
19900: AND ktrx.tsu_code = 'ENTERED'
19901: AND ktrx.rbr_code is NOT NULL
19902: AND ktrx.tcn_type = 'TRBK'