APPS.OKL_LOSS_PROV_PVT dependencies on OKL_STRM_TYPE_B

Line 214: FROM OKL_STRM_TYPE_B sty,

210: WHERE id = p_cntrct_id;
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'

Line 229: FROM OKL_STRM_TYPE_B sty,

225: -- cursor for retrieveing earlier principal balance amount if principal balance
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'

Line 239: FROM OKL_STRM_TYPE_B sty,

235: AND sty.id = p_prin_bal_id
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'

Line 1221: OKL_STRM_TYPE_B sty,

1217: sty.stream_type_subclass sty_subclass,
1218: poc.streams_to_date streams_to_date
1219: FROM OKL_POOLS pol,
1220: OKL_POOL_CONTENTS poc,
1221: OKL_STRM_TYPE_B sty,
1222: OKC_K_HEADERS_B chr,
1223: OKL_K_HEADERS khr
1224: WHERE pol.khr_id = p_agr_id
1225: AND pol.id = poc.pol_id

Line 1252: FROM OKL_STRM_TYPE_B sty,

1248:
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

Line 2367: -- FROM OKL_STRM_TYPE_B sty, OKL_TRX_CONTRACTS_V trx, OKL_TXL_CNTRCT_LNS_V txl

2363:
2364: -- Cursor to verify if the stream type selected is the same as used earlier
2365: -- CURSOR sty_id_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
2366: -- SELECT DISTINCT sty.id id
2367: -- FROM OKL_STRM_TYPE_B sty, OKL_TRX_CONTRACTS_V trx, OKL_TXL_CNTRCT_LNS_V txl
2368: -- WHERE trx.khr_id = p_ctr_id
2369: -- AND trx.tcn_type = 'PSP'
2370: -- AND trx.tsu_code = l_tsu_code
2371: -- AND trx.id = txl.tcn_id