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_DAILY_INTEREST_CALC_PVT dependencies on OKL_STREAMS_V

Line 850: from okl_streams_v stm

846: order by khr.contract_number;
847:
848: --get principal paid as of a given date
849: Cursor c_principal_paid_csr(cp_khr_id IN NUMBER, cp_from_date IN DATE) IS select nvl(sum(sel.amount), 0) principal_paid
850: from okl_streams_v stm
851: , okl_strm_type_v sty
852: , okl_strm_elements_v sel
853: where stm.khr_id = cp_khr_id
854: and stm.sty_id = sty.id

Line 861: from okl_streams_v stm

857: and sel.stream_element_date <= trunc(cp_from_date);
858:
859: --get excess principal paid
860: Cursor c_excess_principal_paid_csr(cp_khr_id IN NUMBER) IS select nvl(sum(sel.amount), 0) excess_principal_paid
861: from okl_streams_v stm
862: , okl_strm_type_v sty
863: , okl_strm_elements_v sel
864: where stm.khr_id = cp_khr_id
865: and stm.sty_id = sty.id

Line 934: from okl_streams_v stm

930:
931: --get existing daily interest streams
932: Cursor c_daily_int_stm_csr(cp_khr_id IN NUMBER, cp_sty_purpose IN VARCHAR2, cp_receipt_date IN DATE) IS
933: select sum(sel.amount) exist_amount
934: from okl_streams_v stm
935: , okl_strm_type_v sty
936: , okl_strm_elements_v sel
937: where stm.khr_id = cp_khr_id
938: and stm.sty_id = sty.id