APPS.OKL_LTE_INT_PVT dependencies on OKL_STRM_ELEMENTS_V

Line 76: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;

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;
78:
79: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
80: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;

Line 86: l_sel_id Okl_strm_elements_v.sel_id%TYPE;

82:
83: l_selv_rec Okl_Sel_Pvt.selv_rec_type;
84: lx_selv_rec Okl_Sel_Pvt.selv_rec_type;
85: l_init_selv_rec Okl_Sel_Pvt.selv_rec_type;
86: l_sel_id Okl_strm_elements_v.sel_id%TYPE;
87:
88: ------------------------------------------------------------
89: --Consolidated invoices for Late Interest Cursor
90: ------------------------------------------------------------

Line 329: FROM okl_strm_elements_v

325: -- Stream Element Line Number Cursor
326: ------------------------------------------------------------
327: CURSOR l_stream_line_nbr_csr(cp_stm_id IN NUMBER) IS
328: SELECT nvl(max(se_line_number), 0) se_line_number
329: FROM okl_strm_elements_v
330: WHERE stm_id = cp_stm_id;
331:
332: ------------------------------------------------------------
333: -- Securitized streams Cursor

Line 388: ,okl_strm_elements_v sel

384:
385: CURSOR c_src_sel(cp_stream_id IN NUMBER) IS
386: SELECT sel.source_id
387: FROM okl_bpd_ar_inv_lines_v arl
388: ,okl_strm_elements_v sel
389: WHERE arl.id = cp_stream_id
390: AND arl.sel_id = sel.id;
391:
392: