APPS.OKL_TIL_PVT dependencies on OKL_STRM_TMPT_FULL_UV

Line 308: OKL_STRM_TMPT_FULL_UV st,

304: FROM OKL_STRM_TYPE_B
305: WHERE id = p_tilv_rec.sty_id;*/
306: SELECT '1'
307: FROM
308: OKL_STRM_TMPT_FULL_UV st,
309: OKL_K_HEADERS KHR,
310: OKL_TRX_AR_INVOICES_B invoice
311: WHERE
312: invoice.id = p_tilv_rec.tai_id

Line 318: lv_sty_name OKL_STRM_TMPT_FULL_UV.sty_name%TYPE;

314: AND st.TMPT_STATUS = 'ACTIVE'
315: AND st.sty_id = p_tilv_rec.sty_id
316: AND invoice.khr_id(+) = khr.id;
317:
318: lv_sty_name OKL_STRM_TMPT_FULL_UV.sty_name%TYPE;
319: -- cursor to pick up the stream name to show in the message
320: CURSOR l_sty_name_csr IS
321: SELECT st.NAME
322: FROM OKL_STRM_TYPE_V st