DBA Data[Home] [Help]

APPS.OKL_ESG_TRANSPORT_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 147: ,okc_k_headers_all_b chr

143: select gts.deal_type
144: ,gts.interest_calc_meth_code
145: from okl_sys_acct_opts_all sao
146: ,okl_stream_interfaces osi
147: ,okc_k_headers_all_b chr
148: ,okl_k_headers khr
149: ,okl_products pdt
150: ,okl_ae_tmpt_sets_all aes
151: ,okl_st_gen_tmpt_sets_all gts

Line 238: FROM okc_k_headers_all_b rbk_chr,

234:
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'

Line 247: FROM okc_k_headers_all_b orig_chr,

243: AND rbk_chr.id = p_khr_id
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'