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_STRM_ELEMENTS_V

Line 852: , okl_strm_elements_v sel

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
855: and sty.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'
856: and stm.id = sel.stm_id

Line 863: , okl_strm_elements_v sel

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
866: and sty.stream_type_purpose = 'EXCESS_LOAN_PAYMENT_PAID'
867: and stm.id = sel.stm_id;

Line 936: , okl_strm_elements_v sel

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
939: and sty.stream_type_purpose = cp_sty_purpose
940: and stm.id = sel.stm_id