APPS.OKL_STREAMS_UTIL dependencies on OKC_K_HEADERS_ALL_B

Line 2833: FROM okc_k_headers_all_b rbk_chr,

2829: trx.date_transaction_occurred revision_date,
2830: 'ONLINE_REBOOK' rebook_type
2831: ,rbk_chr.start_date rbk_chr_start_date
2832: ,orig_chr.start_date orig_chr_start_date
2833: FROM okc_k_headers_all_b rbk_chr,
2834: okc_k_headers_all_b orig_chr,
2835: okl_trx_contracts_all trx
2836: WHERE rbk_chr.id = p_khr_id
2837: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'

Line 2834: okc_k_headers_all_b orig_chr,

2830: 'ONLINE_REBOOK' rebook_type
2831: ,rbk_chr.start_date rbk_chr_start_date
2832: ,orig_chr.start_date orig_chr_start_date
2833: FROM okc_k_headers_all_b rbk_chr,
2834: okc_k_headers_all_b orig_chr,
2835: okl_trx_contracts_all trx
2836: WHERE rbk_chr.id = p_khr_id
2837: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'
2838: AND trx.khr_id_new = rbk_chr.id

Line 2850: FROM okc_k_headers_all_b orig_chr,

2846: trx.date_transaction_occurred revision_date,
2847: 'MASS_REBOOK' rebook_type
2848: ,orig_chr.start_date rbk_chr_start_date
2849: ,orig_chr.start_date orig_chr_start_date
2850: FROM okc_k_headers_all_b orig_chr,
2851: okl_trx_contracts_all trx
2852: WHERE orig_chr.id = p_khr_id
2853: AND trx.khr_id = orig_chr.id
2854: AND trx.tsu_code = 'ENTERED'

Line 2891: ,okc_k_headers_all_b chr

2887: ,gts.deal_type
2888: ,gts.interest_calc_meth_code
2889: from okl_sys_acct_opts_all sao
2890: ,okl_stream_interfaces osi
2891: ,okc_k_headers_all_b chr
2892: ,okl_k_headers khr
2893: ,okl_products pdt
2894: ,okl_ae_tmpt_sets_all aes
2895: ,okl_st_gen_tmpt_sets_all gts

Line 3025: from okc_k_headers_all_b chr

3021: cursor get_chr_details( p_khr_id IN NUMBER )
3022: IS
3023: select gts.deal_type deal_type
3024: ,gts.interest_calc_meth_code interest_calc_meth_code
3025: from okc_k_headers_all_b chr
3026: ,okl_k_headers khr
3027: ,okl_products pdt
3028: ,okl_ae_tmpt_sets_all aes
3029: ,okl_st_gen_tmpt_sets_all gts

Line 3148: ,okc_k_headers_all_b chr

3144: ,osi.date_delivery reamort_date
3145: ,siyb.target_value target_value
3146: FROM okl_stream_interfaces osi
3147: ,okl_sif_yields siyb
3148: ,okc_k_headers_all_b chr
3149: ,okl_k_headers khr
3150: ,okl_products pdt
3151: ,okl_ae_tmpt_sets_all aes
3152: ,okl_st_gen_tmpt_sets_all gts

Line 3234: FROM okc_k_headers_all_b CHR

3230:
3231: CURSOR chk_rbk_rel_csr (p_contract_id IN NUMBER)
3232: IS
3233: SELECT '!'
3234: FROM okc_k_headers_all_b CHR
3235: WHERE CHR.ID = p_contract_id
3236: AND CHR.orig_system_source_code IN ('OKL_REBOOK','OKL_RELEASE');
3237:
3238: CURSOR get_bal_amt_date