APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_PRODUCTS

Line 43: okl_products_v pdt

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

Line 2016: okl_products_v pdt

2012: chr.currency_code currency_code,
2013: khr.term_duration term
2014: from okc_k_headers_v chr,
2015: okl_k_headers khr,
2016: okl_products_v pdt
2017: where khr.id = chr.id
2018: and chr.id = p_khr_id
2019: and khr.pdt_id = pdt.id(+);
2020:

Line 11863: okl_products_v pdt

11859: SELECT to_char(pdt.id) pid,
11860: chr.currency_code currency_code
11861: FROM okc_k_headers_v chr,
11862: okl_k_headers khr,
11863: okl_products_v pdt
11864: WHERE khr.id = chr.id
11865: AND chr.id = p_khr_id
11866: AND khr.pdt_id = pdt.id(+);
11867:

Line 11872: l_pdt_id okl_products.id%type;

11868: l_sty_purpose okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE;
11869: l_sty_id okl_strm_type_b.ID%TYPE;
11870: l_sty_name OKL_STRM_TYPE_v.name%TYPE;
11871: l_mapped_sty_name OKL_STRM_TYPE_v.name%TYPE;
11872: l_pdt_id okl_products.id%type;
11873: l_currency_code okc_k_headers_all_b.currency_code%type;
11874: l_purpose_code VARCHAR2(30) := '-99';
11875:
11876: l_selv_tbl okl_streams_pub.selv_tbl_type;