[Home] [Help]
22: /*SELECT distinct id
23: FROM okl_strm_type_b
24: WHERE BILLABLE_YN = 'Y';*/
25: SELECT sty_id
26: FROM okl_strm_tmpt_all_types_uv sty
27: WHERE sty.BILLABLE_YN = 'Y'
28: and not exists (select 1 from OKL_STRM_TYPE_EXEMPT_V sem
29: where sem.lpo_id = p_lpo_id
30: and sem.sty_id = sty.sty_id);