APPS.OKL_LTE_INT_PVT dependencies on OKL_STREAMS_V

Line 76: l_stm_id OKL_STREAMS_V.ID%TYPE;

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

Line 427: FROM okl_streams_v stm

423: -- cursor for AR invoices
424: CURSOR l_AR_stream_csr(cp_khr_id IN NUMBER
425: ,cp_sty_id IN NUMBER) IS
426: SELECT stm.id
427: FROM okl_streams_v stm
428: WHERE stm.khr_id = cp_khr_id
429: AND stm.sty_id = cp_sty_id
430: AND stm.say_code = 'CURR'
431: AND stm.active_yn = 'Y';

Line 438: FROM okl_streams_v stm

434: CURSOR l_cons_stream_csr(cp_khr_id IN NUMBER
435: ,cp_kle_id IN NUMBER
436: ,cp_sty_id IN NUMBER) IS
437: SELECT stm.id
438: FROM okl_streams_v stm
439: WHERE stm.khr_id = cp_khr_id
440: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, -99)
441: AND stm.sty_id = cp_sty_id
442: AND stm.say_code = 'CURR'