APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKC_K_HEADERS_V

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

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

Line 45: from okc_k_headers_v chr,

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

Line 2029: from okc_k_headers_v chr,

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

Line 14329: FROM okc_k_headers_v chr,

14325: CURSOR c_hdr IS
14326: SELECT to_char(pdt.id) pid,
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