DBA Data[Home] [Help]

APPS.OKL_ESG_TRANSPORT_PVT dependencies on OKL_TRX_CONTRACTS_ALL

Line 239: okl_trx_contracts_all trx

235: CURSOR get_orig_contract_csr( p_khr_id IN NUMBER)
236: IS
237: SELECT rbk_chr.orig_system_id1 original_chr_id
238: FROM okc_k_headers_all_b rbk_chr,
239: okl_trx_contracts_all trx
240: WHERE trx.khr_id_new = rbk_chr.id
241: AND trx.tsu_code = 'ENTERED'
242: AND trx.tcn_type = 'TRBK'
243: AND rbk_chr.id = p_khr_id

Line 248: okl_trx_contracts_all trx

244: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'
245: UNION
246: SELECT orig_chr.id original_chr_id
247: FROM okc_k_headers_all_b orig_chr,
248: okl_trx_contracts_all trx
249: WHERE orig_chr.id = p_khr_id
250: AND trx.khr_id = orig_chr.id
251: AND trx.tsu_code = 'ENTERED'
252: AND trx.tcn_type = 'TRBK'