APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_PRODUCTS

Line 47: okl_products_v pdt

43: chr.currency_code currency_code,
44: khr.term_duration term
45: from okc_k_headers_v chr,
46: okl_k_headers khr,
47: okl_products_v pdt
48: where khr.id = chr.id
49: and chr.id = p_khr_id
50: and khr.pdt_id = pdt.id(+);
51: r_hdr G_HDR%ROWTYPE;

Line 2031: okl_products_v pdt

2027: chr.currency_code currency_code,
2028: khr.term_duration term
2029: from okc_k_headers_v chr,
2030: okl_k_headers khr,
2031: okl_products_v pdt
2032: where khr.id = chr.id
2033: and chr.id = p_khr_id
2034: and khr.pdt_id = pdt.id(+);
2035:

Line 6370: CURSOR c_chk_accrual_sty_on_pdt(cp_pdt_id OKL_PRODUCTS.ID%TYPE,

6366: and ole.id = cp_ole_id
6367: and ole.lse_id = cle.lse_id
6368: and ole.id=cle.orig_system_id1;
6369:
6370: CURSOR c_chk_accrual_sty_on_pdt(cp_pdt_id OKL_PRODUCTS.ID%TYPE,
6371: cp_sty_id OKL_STRM_TYPE_B.ID%TYPE) IS
6372: SELECT 'Y'
6373: FROM OKL_STRM_TYPE_B sty,
6374: OKL_PROD_STRM_TYPES psty

Line 6390: okl_products pdt

6386: --To get the reporting product id
6387: CURSOR c_get_report_product_id IS
6388: SELECT pdt.reporting_pdt_id
6389: FROM okl_k_headers khr,
6390: okl_products pdt
6391: WHERE khr.id = p_chr_id
6392: AND khr.pdt_id = pdt.id;
6393:
6394: -- Cursor to identify the Stream ID corresponding to the one that

Line 6481: l_product_id okl_products.id%TYPE;

6477: l_del_stm_id_tbl l_del_stm_id_tbl_type;
6478: l_del_stm_id_idx NUMBER := 0;
6479: l_wrk_strm_trx_number NUMBER;
6480: l_accrual_previous_mnth_yn VARCHAR2(3);
6481: l_product_id okl_products.id%TYPE;
6482: l_temp_term_date DATE;
6483: l_param_termination_date DATE;
6484: l_chk_accrual_stream VARCHAR2(1);
6485: l_curr_term_flag VARCHAR2(1);

Line 14331: okl_products_v pdt

14327: chr.currency_code currency_code,
14328: khr.multi_gaap_yn multi_gaap_yn -- R12.1.2
14329: FROM okc_k_headers_v chr,
14330: okl_k_headers khr,
14331: okl_products_v pdt
14332: WHERE khr.id = chr.id
14333: AND chr.id = p_khr_id
14334: AND khr.pdt_id = pdt.id(+);
14335:

Line 14341: from okl_products

14337: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
14338:
14339: cursor rep_pdt_csr(p_pdt_id number) is
14340: select reporting_pdt_id
14341: from okl_products
14342: where id = p_pdt_id;
14343:
14344: l_rep_pdt_id okl_products.id%TYPE;
14345: TYPE t_pdt_tbl is table of number index by binary_integer;

Line 14344: l_rep_pdt_id okl_products.id%TYPE;

14340: select reporting_pdt_id
14341: from okl_products
14342: where id = p_pdt_id;
14343:
14344: l_rep_pdt_id okl_products.id%TYPE;
14345: TYPE t_pdt_tbl is table of number index by binary_integer;
14346: l_pdt_tbl t_pdt_tbl;
14347: l_rep_flag t_pdt_tbl;
14348: -- R12.1.2 end.

Line 14354: l_pdt_id okl_products.id%type;

14350: l_sty_purpose okl_strm_type_b.STREAM_TYPE_PURPOSE%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;