APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKL_STREAMS_V

Line 142: okl_streams_v stm,

138: BETWEEN TRUNC(NVL(cp_from_date, khr.start_date)) AND TRUNC(NVL(cp_to_date, SYSDATE))
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)

Line 728: okl_streams_v stm,

724: BETWEEN TRUNC(NVL(cp_from_date, khr.start_date)) AND TRUNC(NVL(cp_to_date, SYSDATE))
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)

Line 777: okl_streams_v stm,

773: having SUM(AMOUNT_LINE_ITEMS_REMAINING)< SUM(AMOUNT)
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)

Line 817: --okl_streams_v stm,

813: --AND sty.stream_type_purpose IN ('PRINCIPAL_PAYMENT', 'UNSCHEDULED_PRINCIPAL_PAYMENT', 'PRINCIPAL_CATCHUP')
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)

Line 1627: FROM okl_streams_v stm,

1623: l_excess_loan_payment NUMBER;
1624:
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

Line 1812: FROM okl_streams_v stm,

1808: AND khr.id = cp_khr_id;
1809:
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