DBA Data[Home] [Help]

APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKC_K_HEADERS_V

Line 29: CURSOR G_HDR( p_khr_id OKC_K_HEADERS_V.ID%TYPE) IS

25: G_DIFF_LOOKUP_CODE FND_LOOKUPS.LOOKUP_CODE%TYPE;
26: G_PRECISION NUMBER;
27: G_ROUNDING_RULE OKL_SYS_ACCT_OPTS.AEL_ROUNDING_RULE%TYPE;
28:
29: CURSOR G_HDR( p_khr_id OKC_K_HEADERS_V.ID%TYPE) IS
30: select chr.orig_system_source_code,
31: chr.start_date,
32: chr.end_date,
33: chr.template_yn,

Line 41: from okc_k_headers_v chr,

37: to_char(pdt.id) pid,
38: nvl(pdt.reporting_pdt_id, -1) report_pdt_id,
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

Line 2014: from okc_k_headers_v chr,

2010: to_char(pdt.id) pid, --358660899972842057983133434721270318297
2011: nvl(pdt.reporting_pdt_id, -1) report_pdt_id,
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

Line 11861: FROM okc_k_headers_v chr,

11857:
11858: CURSOR c_hdr IS
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