APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 8418: FROM okc_k_headers_all_b rbk_chr,

8414: trx.date_transaction_occurred revision_date,
8415: 'ONLINE_REBOOK' rebook_type
8416: ,rbk_chr.start_date rbk_chr_start_date
8417: ,orig_chr.start_date orig_chr_start_date
8418: FROM okc_k_headers_all_b rbk_chr,
8419: okc_k_headers_all_b orig_chr,
8420: okl_trx_contracts_all trx
8421: WHERE rbk_chr.id = p_khr_id
8422: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'

Line 8419: okc_k_headers_all_b orig_chr,

8415: 'ONLINE_REBOOK' rebook_type
8416: ,rbk_chr.start_date rbk_chr_start_date
8417: ,orig_chr.start_date orig_chr_start_date
8418: FROM okc_k_headers_all_b rbk_chr,
8419: okc_k_headers_all_b orig_chr,
8420: okl_trx_contracts_all trx
8421: WHERE rbk_chr.id = p_khr_id
8422: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'
8423: AND trx.khr_id_new = rbk_chr.id

Line 8435: FROM okc_k_headers_all_b orig_chr,

8431: trx.date_transaction_occurred revision_date,
8432: 'MASS_REBOOK' rebook_type
8433: ,orig_chr.start_date rbk_chr_start_date
8434: ,orig_chr.start_date orig_chr_start_date
8435: FROM okc_k_headers_all_b orig_chr,
8436: okl_trx_contracts_all trx
8437: WHERE orig_chr.id = p_khr_id
8438: AND trx.khr_id = orig_chr.id
8439: AND trx.tsu_code = 'ENTERED'

Line 14101: l_curreny_code okc_k_headers_all_b.currency_code%type;

14097: SELECT chr.currency_code
14098: FROM okc_k_headers_b chr
14099: WHERE chr.id = p_khr_id;
14100:
14101: l_curreny_code okc_k_headers_all_b.currency_code%type;
14102:
14103: l_recurrence_date DATE := NULL;
14104: l_old_cle_id NUMBER;
14105: l_old_sty_id NUMBER;

Line 14355: l_currency_code okc_k_headers_all_b.currency_code%type;

14351: l_sty_id okl_strm_type_b.ID%TYPE;
14352: l_sty_name OKL_STRM_TYPE_v.name%TYPE;
14353: l_mapped_sty_name OKL_STRM_TYPE_v.name%TYPE;
14354: l_pdt_id okl_products.id%type;
14355: l_currency_code okc_k_headers_all_b.currency_code%type;
14356: l_purpose_code VARCHAR2(30) := '-99';
14357:
14358: l_selv_tbl okl_streams_pub.selv_tbl_type;
14359: lx_selv_tbl okl_streams_pub.selv_tbl_type;

Line 14699: l_currency_code okc_k_headers_all_b.currency_code%type;

14695: SELECT chr.currency_code
14696: FROM okc_k_headers_b chr
14697: WHERE chr.id = p_khr_id;
14698:
14699: l_currency_code okc_k_headers_all_b.currency_code%type;
14700: l_purpose_code VARCHAR2(10) := '-99';
14701: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
14702:
14703: -- R12.1.2 .. start