APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKL_STRM_ELEMENTS

Line 85: okl_strm_elements sel,

81: UNION
82: SELECT sum(aps.amount_due_original) interest_billed_amount
83: FROM okl_cnsld_ar_strms_b lsm,
84: okl_strm_type_v sty,
85: okl_strm_elements sel,
86: ar_payment_schedules_all aps,
87: okl_k_headers_full_v khr
88: WHERE lsm.khr_id = cp_khr_id
89: AND lsm.khr_id = khr.id

Line 196: okl_strm_elements sel,

192: UNION ALL
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

Line 231: --okl_strm_elements sel,

227: ----fix for bug # 4746404
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

Line 346: FROM okl_strm_elements sel,

342:
343: CURSOR l_interest_due_csr (cp_khr_id NUMBER,
344: p_due_date DATE) IS
345: SELECT NVL(SUM(amount),0)
346: FROM okl_strm_elements sel,
347: okl_streams str,
348: okl_strm_type_v sty
349: WHERE sel.stm_id = str.id
350: AND str.khr_id = cp_khr_id

Line 579: okl_strm_elements sel

575: p_due_date DATE) IS
576:
577: SELECT MAX(sel.stream_element_date)
578: FROM
579: okl_strm_elements sel
580: ,okl_streams str
581: ,okl_strm_type_v sty
582: WHERE sel.stm_id = str.id
583: AND str.khr_id = p_contract_id

Line 595: okl_strm_elements sel

591: Cursor sch_ctr_prin_bal_date_csr (p_contract_id NUMBER,
592: p_due_date DATE) IS
593: SELECT MAX(sel.stream_element_date)
594: FROM
595: okl_strm_elements sel
596: ,okl_streams str
597: ,okl_strm_type_v sty
598: WHERE sel.stm_id = str.id
599: AND str.khr_id = p_contract_id

Line 827: okl_strm_elements sel,

823: UNION ALL
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

Line 865: --okl_strm_elements sel,

861: --UNION
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

Line 1676: okl_strm_elements_v sel

1672: CURSOR l_laon_payment_csr(cp_khr_id IN NUMBER) IS
1673: SELECT NVL(SUM(sel.amount), 0) loan_excess_amount
1674: FROM okl_streams_v stm,
1675: okl_strm_type_v sty,
1676: okl_strm_elements_v sel
1677: WHERE stm.khr_id = cp_khr_id
1678: AND stm.id = sel.stm_id
1679: AND stm.sty_id = sty.id
1680: AND sty.stream_type_purpose = 'EXCESS_LOAN_PAYMENT_PAID';

Line 1861: okl_strm_elements_v sel

1857: CURSOR l_stream_csr(cp_khr_id IN NUMBER, cp_term_date IN DATE) IS
1858: SELECT max(sel.stream_element_date)
1859: FROM okl_streams_v stm,
1860: okl_strm_type_v sty,
1861: okl_strm_elements_v sel
1862: WHERE stm.khr_id = cp_khr_id
1863: AND stm.id = sel.stm_id
1864: AND stm.sty_id = sty.id
1865: AND sty.stream_type_purpose = 'RENT'