APPS.OKL_LPO_STRM_PVT dependencies on OKL_STRM_TYPE_EXEMPT_V

Line 28: and not exists (select 1 from OKL_STRM_TYPE_EXEMPT_V sem

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);
31:
32: BEGIN