APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKL_STRM_ELEMENTS

Line 143: okl_strm_elements sel,

139: UNION ALL
140: SELECT NVL(SUM(sel.amount),0) interest_paid_amount
141: FROM okl_strm_type_v sty,
142: okl_streams_v stm,
143: okl_strm_elements sel,
144: okc_k_headers_b khr
145: WHERE stm.khr_id = cp_khr_id
146: AND stm.kle_id = NVL(cp_kle_id, stm.kle_id)
147: AND stm.khr_id = khr.id

Line 260: FROM okl_strm_elements sel,

256:
257: CURSOR l_interest_due_csr (cp_khr_id NUMBER,
258: p_due_date DATE) IS
259: SELECT NVL(SUM(amount),0)
260: FROM okl_strm_elements sel,
261: okl_streams str,
262: okl_strm_type_v sty
263: WHERE sel.stm_id = str.id
264: AND str.khr_id = cp_khr_id

Line 493: okl_strm_elements sel

489: p_due_date DATE) IS
490:
491: SELECT MAX(sel.stream_element_date)
492: FROM
493: okl_strm_elements sel
494: ,okl_streams str
495: ,okl_strm_type_v sty
496: WHERE sel.stm_id = str.id
497: AND str.khr_id = p_contract_id

Line 509: okl_strm_elements sel

505: Cursor sch_ctr_prin_bal_date_csr (p_contract_id NUMBER,
506: p_due_date DATE) IS
507: SELECT MAX(sel.stream_element_date)
508: FROM
509: okl_strm_elements sel
510: ,okl_streams str
511: ,okl_strm_type_v sty
512: WHERE sel.stm_id = str.id
513: AND str.khr_id = p_contract_id

Line 729: okl_strm_elements sel,

725: UNION ALL
726: SELECT NVL(SUM(sel.amount),0) principal_paid_amount
727: FROM okl_strm_type_v sty,
728: okl_streams_v stm,
729: okl_strm_elements sel,
730: okc_k_headers_b khr
731: WHERE stm.khr_id = cp_khr_id
732: AND stm.kle_id = NVL(null, stm.kle_id)
733: AND stm.khr_id = khr.id

Line 778: okl_strm_elements sel,

774: UNION ALL
775: SELECT NVL(SUM(sel.amount),0) principal_paid_amount
776: FROM okl_strm_type_v sty,
777: okl_streams_v stm,
778: okl_strm_elements sel,
779: okc_k_headers_b khr
780: WHERE stm.khr_id = cp_khr_id
781: AND stm.kle_id = NVL(null, stm.kle_id)
782: AND stm.khr_id = khr.id

Line 818: --okl_strm_elements sel,

814: --UNION
815: --SELECT NVL(SUM(sel.amount),0) principal_paid_amount
816: --FROM okl_strm_type_v sty,
817: --okl_streams_v stm,
818: --okl_strm_elements sel,
819: --okc_k_headers_b khr
820: --WHERE stm.khr_id = cp_khr_id
821: --AND stm.kle_id = NVL(cp_kle_id, stm.kle_id)
822: --AND stm.khr_id = khr.id

Line 1629: okl_strm_elements_v sel

1625: CURSOR l_laon_payment_csr(cp_khr_id IN NUMBER) IS
1626: SELECT NVL(SUM(sel.amount), 0) loan_excess_amount
1627: FROM okl_streams_v stm,
1628: okl_strm_type_v sty,
1629: okl_strm_elements_v sel
1630: WHERE stm.khr_id = cp_khr_id
1631: AND stm.id = sel.stm_id
1632: AND stm.sty_id = sty.id
1633: AND sty.stream_type_purpose = 'EXCESS_LOAN_PAYMENT_PAID';

Line 1814: okl_strm_elements_v sel

1810: CURSOR l_stream_csr(cp_khr_id IN NUMBER, cp_term_date IN DATE) IS
1811: SELECT max(sel.stream_element_date)
1812: FROM okl_streams_v stm,
1813: okl_strm_type_v sty,
1814: okl_strm_elements_v sel
1815: WHERE stm.khr_id = cp_khr_id
1816: AND stm.id = sel.stm_id
1817: AND stm.sty_id = sty.id
1818: AND sty.stream_type_purpose = 'RENT'

Line 2231: FROM okl_strm_elements sel

2227:
2228: CURSOR check_prin_payment_csr (p_contract_id NUMBER,
2229: p_line_id NUMBER) IS
2230: SELECT 'Y'
2231: FROM okl_strm_elements sel
2232: ,okl_streams str
2233: ,okl_strm_type_v sty
2234: WHERE sel.stm_id = str.id
2235: AND str.khr_id = p_contract_id

Line 2245: FROM okl_strm_elements sel

2241:
2242: CURSOR check_prin_balance_csr (p_contract_id NUMBER,
2243: p_line_id NUMBER) IS
2244: SELECT 'Y'
2245: FROM okl_strm_elements sel
2246: ,okl_streams str
2247: ,okl_strm_type_v sty
2248: WHERE sel.stm_id = str.id
2249: AND str.khr_id = p_contract_id

Line 2518: FROM okl_strm_elements sel

2514:
2515: CURSOR check_chr_streams_csr (p_khr_id IN NUMBER) IS
2516: SELECT 'Y',
2517: chr.contract_number
2518: FROM okl_strm_elements sel
2519: ,okl_streams str
2520: ,okl_strm_type_b sty
2521: ,okc_k_headers_b chr
2522: WHERE chr.id = p_khr_id