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

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

Line 1502: ,okl_streams str

1498: SELECT sel.stream_element_date stream_element_date,
1499: sel.amount amount
1500: FROM
1501: okl_strm_elements sel
1502: ,okl_streams str
1503: ,okl_strm_type_v sty
1504: WHERE sel.stm_id = str.id
1505: AND str.khr_id = p_contract_id
1506: AND str.kle_id = p_line_id

Line 1527: ,okl_streams str

1523: SELECT sel.stream_element_date stream_element_date,
1524: SUM(amount) amount
1525: FROM
1526: okl_strm_elements sel
1527: ,okl_streams str
1528: ,okl_strm_type_v sty
1529: ,okc_k_lines_b cle
1530: ,okc_statuses_b sts
1531: WHERE sel.stm_id = str.id

Line 1557: ,okl_streams str

1553: SELECT sel.stream_element_date stream_element_date,
1554: sel.amount amount
1555: FROM
1556: okl_strm_elements sel
1557: ,okl_streams str
1558: ,okl_strm_type_v sty
1559: WHERE sel.stm_id = str.id
1560: AND str.khr_id = p_contract_id
1561: AND str.kle_id = p_line_id

Line 1579: ,okl_streams str

1575: SELECT sel.stream_element_date stream_element_date,
1576: SUM(amount) amount
1577: FROM
1578: okl_strm_elements sel
1579: ,okl_streams str
1580: ,okl_strm_type_v sty
1581: ,okc_k_lines_b cle
1582: ,okc_statuses_b sts
1583: WHERE sel.stm_id = str.id

Line 1691: ,okl_streams str

1687: SELECT sel.stream_element_date receipt_date,
1688: sum(sel.amount) principal_pmt_rcpt_amt
1689: FROM
1690: okl_strm_elements sel
1691: ,okl_streams str
1692: ,okl_strm_type_v sty
1693: WHERE sel.stm_id = str.id
1694: AND str.khr_id = p_contract_id
1695: AND str.kle_id = NVL(p_line_id, str.kle_id)

Line 1809: ,okl_streams str

1805: SELECT sel.stream_element_date receipt_date,
1806: sum(sel.amount) principal_pmt_rcpt_amt
1807: FROM
1808: okl_strm_elements sel
1809: ,okl_streams str
1810: ,okl_strm_type_v sty
1811: WHERE sel.stm_id = str.id
1812: AND str.khr_id = p_contract_id
1813: AND str.kle_id = NVL(p_line_id, str.kle_id)

Line 2288: ,okl_streams str

2284: sum(sel.amount) txn_amount,
2285: 'R' txn_type
2286: FROM
2287: okl_strm_elements sel
2288: ,okl_streams str
2289: ,okl_strm_type_v sty
2290: WHERE sel.stm_id = str.id
2291: AND str.khr_id = p_contract_id
2292: AND str.say_code = 'CURR'

Line 2779: FROM okl_streams stm,

2775: FUNCTION get_last_int_calc_date(p_khr_id IN NUMBER) RETURN DATE IS
2776: l_ret_date DATE := NULL;
2777:
2778: CURSOR c_int_calc_date_csr(cp_khr_id NUMBER) IS SELECT (max(sel.stream_element_date) - 1) last_interest_calc_date
2779: FROM okl_streams stm,
2780: okl_strm_elements sel,
2781: okl_strm_type_b sty
2782: WHERE stm.khr_id = cp_khr_id
2783: AND stm.id = sel.stm_id

Line 4489: FROM okl_streams stm,

4485: --checks if newly created Daily Interest - Principal stream elements exist
4486: --prior to date passed
4487: CURSOR l_daily_int_strm_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
4488: SELECT 'Y' return_value
4489: FROM okl_streams stm,
4490: okl_strm_type_b sty,
4491: okl_strm_elements sel
4492: WHERE stm.khr_id = cp_khr_id
4493: AND stm.sty_id = sty.id

Line 4507: FROM okl_streams stm,

4503: --checks if newly created Principal Catchup stream elements exist
4504: --prior to date passed
4505: CURSOR l_prin_catch_strm_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
4506: SELECT 'Y' return_value
4507: FROM okl_streams stm,
4508: okl_strm_type_b sty,
4509: okl_strm_elements sel
4510: WHERE stm.khr_id = cp_khr_id
4511: AND stm.sty_id = sty.id

Line 4908: FROM okl_streams stm,

4904: --get the id's of Daily Interest - Principal stream elements
4905: CURSOR l_daily_int_strm_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
4906: SELECT sel.id source_id
4907: , 'OKL_STRM_ELEMENTS_V' source_table
4908: FROM okl_streams stm,
4909: okl_strm_type_b sty,
4910: okl_strm_elements sel
4911: WHERE stm.khr_id = cp_khr_id
4912: AND stm.sty_id = sty.id

Line 4927: FROM okl_streams stm,

4923: --get the id's of Principal Catchup stream elements
4924: CURSOR l_prin_catch_strm_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
4925: SELECT sel.id source_id
4926: , 'OKL_STRM_ELEMENTS_V' source_table
4927: FROM okl_streams stm,
4928: okl_strm_type_b sty,
4929: okl_strm_elements sel
4930: WHERE stm.khr_id = cp_khr_id
4931: AND stm.sty_id = sty.id