APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_TRX_CONTRACTS

Line 7119: okl_trx_contracts ktrx

7115: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
7116: SELECT '!',
7117: orig_system_id1
7118: FROM okc_k_headers_b CHR,
7119: okl_trx_contracts ktrx
7120: WHERE ktrx.khr_id_new = chr.id
7121: AND ktrx.tsu_code = 'ENTERED'
7122: AND ktrx.rbr_code is NOT NULL
7123: AND ktrx.tcn_type = 'TRBK'

Line 12088: okl_trx_contracts ktrx

12084: --cursor to check if the contract is undergoing on-line rebook
12085: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
12086: SELECT '!'
12087: FROM okc_k_headers_b CHR,
12088: okl_trx_contracts ktrx
12089: WHERE ktrx.khr_id_new = chr.id
12090: AND ktrx.tsu_code = 'ENTERED'
12091: AND ktrx.rbr_code is NOT NULL
12092: AND ktrx.tcn_type = 'TRBK'

Line 12363: okl_trx_contracts ktrx

12359: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
12360: SELECT '!',
12361: chr.orig_system_id1
12362: FROM okc_k_headers_b CHR,
12363: okl_trx_contracts ktrx
12364: WHERE ktrx.khr_id_new = chr.id
12365: AND ktrx.tsu_code = 'ENTERED'
12366: AND ktrx.rbr_code is NOT NULL
12367: AND ktrx.tcn_type = 'TRBK'