APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKL_STRM_ELEMENTS_V

Line 308: FROM okl_strm_elements_v ste

304: ,ste.stream_element_date
305: ,stm.khr_id
306: ,stm.kle_id
307: ,stm.sty_id
308: FROM okl_strm_elements_v ste
309: ,okl_streams_v stm
310: ,okl_strm_type_v sty
311: WHERE ste.stm_id = stm.id
312: AND stm.khr_id = p_khr_id

Line 355: FROM okl_strm_elements_v

351: -- Stream Element Line Number Cursor
352: ------------------------------------------------------------
353: CURSOR l_stream_line_nbr_csr(cp_stm_id IN NUMBER) IS
354: SELECT max(se_line_number) se_line_number
355: FROM okl_strm_elements_v
356: WHERE stm_id = cp_stm_id;
357:
358: ------------------------------------------------------------
359: -- Initialise constants

Line 413: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;

409: l_kle_id okl_streams.kle_id%TYPE;
410: l_sty_id okl_strm_type_v.id%TYPE;
411: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
412: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
413: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
414: l_stm_id OKL_STREAMS_V.ID%TYPE;
415: l_sel_id Okl_strm_elements_v.sel_id%TYPE;
416:
417: l_amount NUMBER;

Line 415: l_sel_id Okl_strm_elements_v.sel_id%TYPE;

411: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
412: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
413: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
414: l_stm_id OKL_STREAMS_V.ID%TYPE;
415: l_sel_id Okl_strm_elements_v.sel_id%TYPE;
416:
417: l_amount NUMBER;
418:
419: l_billing_frequency NUMBER;