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_STREAMS_V

Line 272: okl_streams_v stm_prin_pmt,

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
276: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date

Line 610: okl_streams_v stm_prin_pmt,

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
614: AND stm_prin_pmt.id = sel_prin_pmt.stm_id

Line 626: okl_streams_v stm_prin_pmt,

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
630: AND stm_prin_pmt.id = sel_prin_pmt.stm_id

Line 671: okl_streams_v stm_prin_pmt,

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
675: AND sel_prin_pmt.stream_element_date = cp_due_date