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 699: from okl_streams_v stm

695: order by khr.contract_number;
696:
697: --get principal paid as of a given date
698: Cursor c_principal_paid_csr(cp_khr_id IN NUMBER, cp_from_date IN DATE) IS select nvl(sum(sel.amount), 0) principal_paid
699: from okl_streams_v stm
700: , okl_strm_type_v sty
701: , okl_strm_elements_v sel
702: where stm.khr_id = cp_khr_id
703: and stm.sty_id = sty.id

Line 710: from okl_streams_v stm

706: and sel.stream_element_date <= trunc(cp_from_date);
707:
708: --get excess principal paid
709: Cursor c_excess_principal_paid_csr(cp_khr_id IN NUMBER) IS select nvl(sum(sel.amount), 0) excess_principal_paid
710: from okl_streams_v stm
711: , okl_strm_type_v sty
712: , okl_strm_elements_v sel
713: where stm.khr_id = cp_khr_id
714: and stm.sty_id = sty.id

Line 783: from okl_streams_v stm

779:
780: --get existing daily interest streams
781: Cursor c_daily_int_stm_csr(cp_khr_id IN NUMBER, cp_sty_purpose IN VARCHAR2, cp_receipt_date IN DATE) IS
782: select sum(sel.amount) exist_amount
783: from okl_streams_v stm
784: , okl_strm_type_v sty
785: , okl_strm_elements_v sel
786: where stm.khr_id = cp_khr_id
787: and stm.sty_id = sty.id