APPS.OKL_LTE_INT_PVT dependencies on OKL_STREAMS_V

Line 73: l_stm_id OKL_STREAMS_V.ID%TYPE;

69: l_days_calc NUMBER := 0;
70: l_held_until_date DATE;
71:
72: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;
73: l_stm_id OKL_STREAMS_V.ID%TYPE;
74: l_stream_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
75: l_sec_stream_id OKL_CNSLD_AR_STRMS_V.ID%TYPE;
76: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
77: l_error_flag BOOLEAN := FALSE;

Line 303: FROM okl_streams_v stm

299: -- cursor for AR invoices
300: CURSOR l_AR_stream_csr(cp_khr_id IN NUMBER
301: ,cp_sty_id IN NUMBER) IS
302: SELECT stm.id
303: FROM okl_streams_v stm
304: WHERE stm.khr_id = cp_khr_id
305: AND stm.sty_id = cp_sty_id
306: AND stm.say_code = 'CURR'
307: AND stm.active_yn = 'Y';

Line 314: FROM okl_streams_v stm

310: CURSOR l_cons_stream_csr(cp_khr_id IN NUMBER
311: ,cp_kle_id IN NUMBER
312: ,cp_sty_id IN NUMBER) IS
313: SELECT stm.id
314: FROM okl_streams_v stm
315: WHERE stm.khr_id = cp_khr_id
316: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, -99)
317: AND stm.sty_id = cp_sty_id
318: AND stm.say_code = 'CURR'