APPS.OKL_VAR_INT_FLOAT_PVT dependencies on OKL_STRM_TYPE_V

Line 263: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;

259: l_total_loan_pmt NUMBER := 0;
260: l_invoice_id NUMBER;
261: l_invoice_amt NUMBER := 0;
262: l_interest_paid NUMBER := 0;
263: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
264: i_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;
265: r_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;
266: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;
267: variable_int_rev_loan_float EXCEPTION;

Line 271: FROM okl_strm_type_v sty_prin_pmt,

267: variable_int_rev_loan_float EXCEPTION;
268:
269: CURSOR loan_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE, cp_stream_type_purpose VARCHAR2) IS
270: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
271: FROM okl_strm_type_v sty_prin_pmt,
272: okl_streams_v stm_prin_pmt,
273: okl_strm_elements_v sel_prin_pmt
274: WHERE stm_prin_pmt.khr_id = cp_khr_id
275: AND stm_prin_pmt.id = sel_prin_pmt.stm_id

Line 597: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;

593: l_scheduled_prin_pmnt_amt NUMBER := 0;
594: l_invoice_id NUMBER;
595: l_invoice_amt NUMBER := 0;
596: l_interest_paid NUMBER := 0;
597: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
598: i_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;
599: r_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;
600: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;
601: l_kle_id OKL_K_LINES.id%TYPE;

Line 609: FROM okl_strm_type_v sty_prin_pmt,

605:
606: --Added cp_kle_id by bkatraga for bug 13447258
607: CURSOR loan_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE, cp_stream_type_purpose VARCHAR2, cp_kle_id NUMBER) IS
608: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
609: FROM okl_strm_type_v sty_prin_pmt,
610: okl_streams_v stm_prin_pmt,
611: okl_strm_elements_v sel_prin_pmt
612: WHERE stm_prin_pmt.khr_id = cp_khr_id
613: AND stm_prin_pmt.kle_id = cp_kle_id

Line 625: FROM okl_strm_type_v sty_prin_pmt,

621: --Added cp_kle_id by bkatraga for bug 13447258
622: -- Derive the interest billed for previous billing periods
623: CURSOR Interest_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE, cp_kle_id NUMBER) IS
624: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
625: FROM okl_strm_type_v sty_prin_pmt,
626: okl_streams_v stm_prin_pmt,
627: okl_strm_elements_v sel_prin_pmt
628: WHERE stm_prin_pmt.khr_id = cp_khr_id
629: AND stm_prin_pmt.kle_id = cp_kle_id

Line 650: FROM okl_strm_type_v sty,

646: CURSOR Principal_payment_streams_csr (cp_khr_id NUMBER, cp_kle_id NUMBER, cp_due_date DATE) IS
647: SELECT sel.id,
648: sel.stream_element_date,
649: sel.amount
650: FROM okl_strm_type_v sty,
651: okl_streams str,
652: okl_strm_elements sel
653: WHERE sel.stm_id = str.id
654: AND str.khr_id = cp_khr_id

Line 670: FROM okl_strm_type_v sty_prin_pmt,

666:
667:
668: CURSOR scheduled_prin_pmnt_amt_csr (cp_khr_id NUMBER, cp_due_date DATE, cp_stream_type_purpose VARCHAR2) IS
669: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
670: FROM okl_strm_type_v sty_prin_pmt,
671: okl_streams_v stm_prin_pmt,
672: okl_strm_elements_v sel_prin_pmt
673: WHERE stm_prin_pmt.khr_id = cp_khr_id
674: AND stm_prin_pmt.id = sel_prin_pmt.stm_id