APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKL_STRM_ELEMENTS_V

Line 354: FROM okl_strm_elements_v ste

350: ,ste.stream_element_date
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

Line 401: FROM okl_strm_elements_v

397: -- Stream Element Line Number Cursor
398: ------------------------------------------------------------
399: CURSOR l_stream_line_nbr_csr(cp_stm_id IN NUMBER) IS
400: SELECT max(se_line_number) se_line_number
401: FROM okl_strm_elements_v
402: WHERE stm_id = cp_stm_id;
403:
404: ------------------------------------------------------------
405: -- Initialise constants

Line 459: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;

455: l_kle_id okl_streams.kle_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;

Line 461: l_sel_id Okl_strm_elements_v.sel_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:
465: l_billing_frequency NUMBER;