DBA Data[Home] [Help]

APPS.OKL_LPO_STRM_PVT dependencies on OKL_STRM_TMPT_ALL_TYPES_UV

Line 26: FROM okl_strm_tmpt_all_types_uv sty

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);