APPS.OKL_QA_SECURITIZATION dependencies on OKL_STRM_TYPE_B

Line 80: FROM okl_strm_type_b stm,

76: stm.stream_type_subclass stream_type_subclass,
77: tl.description ALLOC_BASIS,
78: stm.capitalize_yn capitalize_yn,
79: stm.periodic_yn periodic_yn
80: FROM okl_strm_type_b stm,
81: OKL_STRM_TYPE_TL tl
82: WHERE tl.id = stm.id
83: and tl.language = 'US'
84: and stm.id = styid;

Line 124: okl_strm_type_b styb

120: CURSOR l_okl_poc_sty_subclass_csr(p_agreement_id IN NUMBER, p_stream_type_subclass IN VARCHAR2) IS
121: SELECT 1
122: FROM okl_pool_contents pocb,
123: okl_pools polb,
124: okl_strm_type_b styb
125: WHERE polb.khr_id = p_agreement_id
126: AND pocb.pol_id = polb.id
127: AND pocb.sty_id = styb.id
128: AND styb.stream_type_subclass = p_stream_type_subclass;