eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VAR_INT_FLOAT_PVT dependencies on OKL_STRM_ELEMENTS_V

Line 266: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;

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;
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

Line 273: okl_strm_elements_v sel_prin_pmt

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
276: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date
277: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 600: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;

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;
602: l_strm_element_date OKL_STRM_ELEMENTS.stream_element_date%TYPE;
603: l_parent_strm_element_id OKL_STRM_ELEMENTS.id%TYPE;
604: var_int_loan_float_failed EXCEPTION;

Line 611: okl_strm_elements_v sel_prin_pmt

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
614: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
615: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date

Line 627: okl_strm_elements_v sel_prin_pmt

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
630: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
631: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date

Line 672: okl_strm_elements_v sel_prin_pmt

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
675: AND sel_prin_pmt.stream_element_date = cp_due_date
676: AND stm_prin_pmt.sty_id = sty_prin_pmt.id