APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_TRX_CONTRACTS

Line 368: okl_trx_contracts ktrx

364: CURSOR l_chk_mass_rbk_csr(p_chr_id IN NUMBER)
365: IS
366: SELECT 'Y'
367: FROM okc_k_headers_b chrb,
368: okl_trx_contracts ktrx
369: WHERE chrb.id = p_chr_id
370: AND ktrx.khr_id = chrb.id
371: AND ktrx.tsu_code = 'ENTERED'
372: AND ktrx.rbr_code IS NOT NULL

Line 1562: okl_trx_contracts ktrx

1558: CURSOR l_rbk_csr(p_chr_id NUMBER)
1559: IS
1560: SELECT ktrx.date_transaction_occurred
1561: FROM okc_k_headers_b chrb,
1562: okl_trx_contracts ktrx
1563: WHERE chrb.ID = p_chr_id
1564: AND ktrx.khr_id = chrb.id
1565: AND ktrx.tsu_code = 'ENTERED'
1566: AND ktrx.rbr_code IS NOT NULL

Line 7513: okl_trx_contracts ktrx

7509: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
7510: SELECT '!',
7511: orig_system_id1
7512: FROM okc_k_headers_b CHR,
7513: okl_trx_contracts ktrx
7514: WHERE ktrx.khr_id_new = chr.id
7515: AND ktrx.tsu_code = 'ENTERED'
7516: AND ktrx.rbr_code is NOT NULL
7517: AND ktrx.tcn_type = 'TRBK'

Line 12511: okl_trx_contracts ktrx

12507: --cursor to check if the contract is undergoing on-line rebook
12508: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
12509: SELECT '!'
12510: FROM okc_k_headers_b CHR,
12511: okl_trx_contracts ktrx
12512: WHERE ktrx.khr_id_new = chr.id
12513: AND ktrx.tsu_code = 'ENTERED'
12514: AND ktrx.rbr_code is NOT NULL
12515: AND ktrx.tcn_type = 'TRBK'

Line 12915: okl_trx_contracts ktrx

12911: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
12912: SELECT '!',
12913: chr.orig_system_id1
12914: FROM okc_k_headers_b CHR,
12915: okl_trx_contracts ktrx
12916: WHERE ktrx.khr_id_new = chr.id
12917: AND ktrx.tsu_code = 'ENTERED'
12918: AND ktrx.rbr_code is NOT NULL
12919: AND ktrx.tcn_type = 'TRBK'

Line 13731: okl_trx_contracts ktrx

13727:
13728: CURSOR l_chk_rbk_csr(p_chr_id IN NUMBER) is
13729: SELECT date_transaction_occurred
13730: FROM okc_k_headers_b chr,
13731: okl_trx_contracts ktrx
13732: WHERE ktrx.khr_id_new = chr.id
13733: AND ktrx.tsu_code = 'ENTERED'
13734: AND ktrx.rbr_code is NOT NULL
13735: AND ktrx.tcn_type = 'TRBK'

Line 13918: okl_trx_contracts ktrx

13914: CURSOR l_chk_rbk_csr(p_chr_id IN NUMBER) is
13915: SELECT date_transaction_occurred,
13916: chr.orig_system_id1 orig_chr_id
13917: FROM okc_k_headers_b chr,
13918: okl_trx_contracts ktrx
13919: WHERE ktrx.khr_id_new = chr.id
13920: AND ktrx.tsu_code = 'ENTERED'
13921: AND ktrx.rbr_code is NOT NULL
13922: AND ktrx.tcn_type = 'TRBK'