DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 3176: FROM okc_k_headers_all_b rbk_chr,

3172: trx.date_transaction_occurred revision_date,
3173: 'ONLINE_REBOOK' rebook_type
3174: ,rbk_chr.start_date rbk_chr_start_date
3175: ,orig_chr.start_date orig_chr_start_date
3176: FROM okc_k_headers_all_b rbk_chr,
3177: okc_k_headers_all_b orig_chr,
3178: okl_trx_contracts_all trx
3179: WHERE rbk_chr.id = p_khr_id
3180: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'

Line 3177: okc_k_headers_all_b orig_chr,

3173: 'ONLINE_REBOOK' rebook_type
3174: ,rbk_chr.start_date rbk_chr_start_date
3175: ,orig_chr.start_date orig_chr_start_date
3176: FROM okc_k_headers_all_b rbk_chr,
3177: okc_k_headers_all_b orig_chr,
3178: okl_trx_contracts_all trx
3179: WHERE rbk_chr.id = p_khr_id
3180: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'
3181: AND trx.khr_id_new = rbk_chr.id

Line 3193: FROM okc_k_headers_all_b orig_chr,

3189: trx.date_transaction_occurred revision_date,
3190: 'MASS_REBOOK' rebook_type
3191: ,orig_chr.start_date rbk_chr_start_date
3192: ,orig_chr.start_date orig_chr_start_date
3193: FROM okc_k_headers_all_b orig_chr,
3194: okl_trx_contracts_all trx
3195: WHERE orig_chr.id = p_khr_id
3196: AND trx.khr_id = orig_chr.id
3197: AND trx.tsu_code = 'ENTERED'