DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_TRX_CONTRACTS_ALL

Line 3178: okl_trx_contracts_all trx

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
3182: AND trx.tsu_code = 'ENTERED'

Line 3194: okl_trx_contracts_all trx

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'
3198: AND trx.tcn_type = 'TRBK'