APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKC_K_HEADERS_B

Line 197: okc_k_headers_b khr

193: SELECT NVL(SUM(sel.amount),0) interest_paid_amount
194: FROM okl_strm_type_v sty,
195: okl_streams_v stm,
196: okl_strm_elements sel,
197: okc_k_headers_b khr
198: WHERE stm.khr_id = cp_khr_id
199: AND stm.kle_id = NVL(null, stm.kle_id)
200: AND stm.khr_id = khr.id
201: AND stm.sty_id = sty.id

Line 232: --okc_k_headers_b khr

228: --SELECT NVL(SUM(sel.amount),0) interest_paid_amount
229: --FROM okl_strm_type_v sty,
230: --okl_streams_v stm,
231: --okl_strm_elements sel,
232: --okc_k_headers_b khr
233: --WHERE stm.khr_id = cp_khr_id
234: --AND stm.khr_id = khr.id
235: --AND stm.sty_id = sty.id
236: --AND sty.stream_type_purpose = 'DAILY_INTEREST_INTEREST'

Line 330: FROM OKC_K_HEADERS_B chr,

326: CURSOR l_contract_info_csr(cp_khr_id IN NUMBER) IS
327: SELECT chr.start_date,
328: chr.currency_code,
329: chr.end_date
330: FROM OKC_K_HEADERS_B chr,
331: OKL_K_HEADERS khr
332: WHERE chr.id = khr.id
333: AND khr.id = cp_khr_id;
334:

Line 564: FROM okc_k_headers_b chr,

560: l_stream_element_date DATE;
561:
562: CURSOR l_principal_basis_csr(cp_khr_id IN NUMBER) IS
563: SELECT chr.start_date, rpm.principal_basis_code
564: FROM okc_k_headers_b chr,
565: okl_k_headers khr,
566: okl_k_rate_params rpm
567: WHERE chr.id = khr.id
568: AND rpm.khr_id = khr.id

Line 828: okc_k_headers_b khr

824: SELECT NVL(SUM(sel.amount),0) principal_paid_amount
825: FROM okl_strm_type_v sty,
826: okl_streams_v stm,
827: okl_strm_elements sel,
828: okc_k_headers_b khr
829: WHERE stm.khr_id = cp_khr_id
830: AND stm.kle_id = NVL(null, stm.kle_id)
831: AND stm.khr_id = khr.id
832: AND stm.sty_id = sty.id

Line 866: --okc_k_headers_b khr

862: --SELECT NVL(SUM(sel.amount),0) principal_paid_amount
863: --FROM okl_strm_type_v sty,
864: --okl_streams_v stm,
865: --okl_strm_elements sel,
866: --okc_k_headers_b khr
867: --WHERE stm.khr_id = cp_khr_id
868: --AND stm.kle_id = NVL(cp_kle_id, stm.kle_id)
869: --AND stm.khr_id = khr.id
870: --AND stm.sty_id = sty.id

Line 1147: FROM OKC_K_HEADERS_B chr,

1143: l_start_date DATE;
1144:
1145: CURSOR l_start_date_csr(cp_khr_id IN NUMBER) IS
1146: SELECT chr.start_date
1147: FROM OKC_K_HEADERS_B chr,
1148: OKL_K_HEADERS khr
1149: WHERE chr.id = khr.id
1150: AND khr.id = cp_khr_id;
1151: BEGIN

Line 1386: --okc_k_headers_b khr

1382: --SELECT NVL(SUM(aps.amount_due_original), 0) interest_billed_amount
1383: --FROM okl_bpd_tld_ar_lines_v tld,
1384: --okl_strm_type_b sty,
1385: --ar_payment_schedules_all aps,
1386: --okc_k_headers_b khr
1387: --WHERE tld.khr_id = cp_khr_id
1388: --AND tld.khr_id = khr.id
1389: --AND tld.sty_id = sty.id
1390: --AND sty.stream_type_purpose = 'FLOAT_FACTOR_ADJUSTMENT'

Line 1852: FROM OKC_K_HEADERS_B chr,

1848:
1849: CURSOR l_date_csr(cp_khr_id IN NUMBER) IS
1850: SELECT chr.start_date,
1851: chr.end_date
1852: FROM OKC_K_HEADERS_B chr,
1853: OKL_K_HEADERS khr
1854: WHERE chr.id = khr.id
1855: AND khr.id = cp_khr_id;
1856: