APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKL_STREAMS_V

Line 355: ,okl_streams_v stm

351: ,stm.khr_id
352: ,stm.kle_id
353: ,stm.sty_id
354: FROM okl_strm_elements_v ste
355: ,okl_streams_v stm
356: ,okl_strm_type_v sty
357: WHERE ste.stm_id = stm.id
358: AND stm.khr_id = p_khr_id
359: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)

Line 389: FROM okl_streams_v stm

385: CURSOR l_stream_csr(cp_khr_id IN NUMBER
386: ,cp_kle_id IN NUMBER
387: ,cp_sty_id IN NUMBER) IS
388: SELECT stm.id
389: FROM okl_streams_v stm
390: WHERE stm.khr_id = cp_khr_id
391: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, -99)
392: AND stm.sty_id = cp_sty_id
393: AND stm.say_code = 'CURR'

Line 460: l_stm_id OKL_STREAMS_V.ID%TYPE;

456: l_sty_id okl_strm_type_v.id%TYPE;
457: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
458: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
459: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
460: l_stm_id OKL_STREAMS_V.ID%TYPE;
461: l_sel_id Okl_strm_elements_v.sel_id%TYPE;
462:
463: l_amount NUMBER;
464: