APPS.OKL_LOSS_PROV_PVT dependencies on OKL_STREAMS

Line 215: OKL_STREAMS stm,

211:
212: CURSOR principal_bal_csr(p_ctr_id NUMBER, p_start_date DATE, p_end_date DATE, p_prin_bal_id NUMBER) IS
213: SELECT SUM(ste.amount)
214: FROM OKL_STRM_TYPE_B sty,
215: OKL_STREAMS stm,
216: OKL_STRM_ELEMENTS ste
217: WHERE stm.khr_id = p_ctr_id
218: AND stm.active_yn = 'Y'
219: AND stm.say_code = 'CURR'

Line 230: OKL_STREAMS stm,

226: -- for given period is not found
227: CURSOR prior_prin_bal_csr(p_ctr_id NUMBER, p_start_date DATE, p_prin_bal_id NUMBER) IS
228: SELECT SUM(ste.amount)
229: FROM OKL_STRM_TYPE_B sty,
230: OKL_STREAMS stm,
231: OKL_STRM_ELEMENTS ste
232: WHERE stm.khr_id = p_ctr_id
233: AND stm.active_yn = 'Y'
234: AND stm.say_code = 'CURR'

Line 240: OKL_STREAMS stm,

236: AND stm.sty_id = sty.id
237: AND ste.stm_id = stm.id
238: AND ste.stream_element_date = (SELECT MAX(stream_element_date)
239: FROM OKL_STRM_TYPE_B sty,
240: OKL_STREAMS stm,
241: OKL_STRM_ELEMENTS ste
242: WHERE stm.khr_id = p_ctr_id
243: AND stm.active_yn = 'Y'
244: AND stm.say_code = 'CURR'

Line 275: OKL_STREAMS_UTIL.get_dependent_stream_type(

271: p_msg_name => 'OKL_AGN_FE_PERD_START_DATE');
272: RAISE Okl_Api.G_EXCEPTION_ERROR;
273: END IF;
274:
275: OKL_STREAMS_UTIL.get_dependent_stream_type(
276: p_khr_id => p_cntrct_id,
277: p_primary_sty_purpose => 'RENT',
278: p_dependent_sty_purpose => 'PRINCIPAL_BALANCE',
279: x_return_status => l_return_status,

Line 1253: OKL_STREAMS stm,

1249: -- cursor to select residual value amount
1250: CURSOR residual_value_csr (p_khr_id NUMBER, p_sty_id NUMBER) IS
1251: SELECT ste.amount
1252: FROM OKL_STRM_TYPE_B sty,
1253: OKL_STREAMS stm,
1254: OKL_STRM_ELEMENTS ste
1255: WHERE stm.khr_id = p_khr_id
1256: AND stm.sty_id = sty.id
1257: AND sty.id = p_sty_id

Line 1553: OKL_STREAMS_UTIL.get_primary_stream_type(

1549:
1550: -- Begin a new PL/SQL block to trap errors related to a praticular contract and to move on to the next contract
1551: BEGIN
1552:
1553: OKL_STREAMS_UTIL.get_primary_stream_type(
1554: p_khr_id => l_cntrct_id,
1555: p_primary_sty_purpose => 'GENERAL_LOSS_PROVISION',
1556: x_return_status => l_return_status,
1557: x_primary_sty_id => l_sty_id);