APPS.OKL_QA_SECURITIZATION dependencies on OKL_STRM_TYPE_V

Line 65: okl_strm_type_v strm

61: strm.stream_type_subclass
62: FROM okc_line_styles_b rev_style,
63: okl_k_lines revl,
64: okc_k_lines_b rev,
65: okl_strm_type_v strm
66: WHERE rev.lse_id = rev_style.id
67: AND rev_style.lty_code = 'REVENUE_SHARE'
68: AND revl.id = rev.id
69: AND rev.cle_id = p_cle_id

Line 88: FROM okl_strm_type_v strm

84: and stm.id = styid;
85:
86: CURSOR inv_dbrmnt_csr(p_cle_id IN NUMBER) IS
87: SELECT name, stream_type_subclass
88: FROM okl_strm_type_v strm
89: WHERE stream_type_subclass = 'INVESTOR_DISBURSEMENT'
90: AND not exists (
91: SELECT 'Y'
92: FROM okc_line_styles_b rev_style,