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

Line 1140: ,okl_streams_v stm_int_pmt

1136: Cursor stream_element_interest_csr (p_line_id NUMBER,
1137: p_stream_element_date DATE) IS
1138: SELECT nvl(sel_int_pmt.amount, 0) interest
1139: FROM okl_strm_type_v sty_int_pmt
1140: ,okl_streams_v stm_int_pmt
1141: ,okl_strm_elements_v sel_int_pmt
1142: WHERE stm_int_pmt.kle_id = p_line_id
1143: AND stm_int_pmt.id = sel_int_pmt.stm_id
1144: AND sel_int_pmt.stream_element_date = p_stream_element_date

Line 1154: ,okl_streams_v stm_prin_pmt

1150: Cursor stream_element_principal_csr (p_line_id NUMBER,
1151: p_stream_element_date DATE) IS
1152: SELECT nvl(sel_prin_pmt.amount, 0) principal
1153: FROM okl_strm_type_v sty_prin_pmt
1154: ,okl_streams_v stm_prin_pmt
1155: ,okl_strm_elements_v sel_prin_pmt
1156: WHERE stm_prin_pmt.kle_id = p_line_id
1157: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
1158: AND sel_prin_pmt.stream_element_date = p_stream_element_date

Line 1226: ,okl_streams_v stm_int_pmt

1222: Cursor strm_elem_int_line_csr (p_line_id NUMBER,
1223: p_stream_element_date DATE) IS
1224: SELECT nvl(sel_int_pmt.amount, 0) interest
1225: FROM okl_strm_type_v sty_int_pmt
1226: ,okl_streams_v stm_int_pmt
1227: ,okl_strm_elements_v sel_int_pmt
1228: WHERE stm_int_pmt.kle_id = p_line_id
1229: AND stm_int_pmt.id = sel_int_pmt.stm_id
1230: AND sel_int_pmt.stream_element_date = p_stream_element_date

Line 1240: ,okl_streams_v stm_prin_pmt

1236: Cursor strm_elem_prin_line_csr (p_line_id NUMBER,
1237: p_stream_element_date DATE) IS
1238: SELECT nvl(sel_prin_pmt.amount, 0) principal
1239: FROM okl_strm_type_v sty_prin_pmt
1240: ,okl_streams_v stm_prin_pmt
1241: ,okl_strm_elements_v sel_prin_pmt
1242: WHERE stm_prin_pmt.kle_id = p_line_id
1243: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
1244: AND sel_prin_pmt.stream_element_date = p_stream_element_date

Line 1254: ,okl_streams_v stm_int_pmt

1250: Cursor strm_elem_int_hdr_csr (p_khr_id NUMBER,
1251: p_stream_element_date DATE) IS
1252: SELECT nvl(sel_int_pmt.amount, 0) interest
1253: FROM okl_strm_type_v sty_int_pmt
1254: ,okl_streams_v stm_int_pmt
1255: ,okl_strm_elements_v sel_int_pmt
1256: WHERE stm_int_pmt.khr_id = p_khr_id
1257: AND stm_int_pmt.id = sel_int_pmt.stm_id
1258: AND sel_int_pmt.stream_element_date = p_stream_element_date

Line 1268: ,okl_streams_v stm_prin_pmt

1264: Cursor strm_elem_prin_hdr_csr ( p_khr_id NUMBER,
1265: p_stream_element_date DATE) IS
1266: SELECT nvl(sel_prin_pmt.amount, 0) principal
1267: FROM okl_strm_type_v sty_prin_pmt
1268: ,okl_streams_v stm_prin_pmt
1269: ,okl_strm_elements_v sel_prin_pmt
1270: WHERE stm_prin_pmt.khr_id = p_khr_id
1271: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
1272: AND sel_prin_pmt.stream_element_date = p_stream_element_date