APPS.OKL_LTE_INT_PVT dependencies on OKL_STRM_ELEMENTS_V

Line 79: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;

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;
81:
82: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
83: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;

Line 89: l_sel_id Okl_strm_elements_v.sel_id%TYPE;

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

Line 453: FROM okl_strm_elements_v

449: -- Stream Element Line Number Cursor
450: ------------------------------------------------------------
451: CURSOR l_stream_line_nbr_csr(cp_stm_id IN NUMBER) IS
452: SELECT nvl(max(se_line_number), 0) se_line_number
453: FROM okl_strm_elements_v
454: WHERE stm_id = cp_stm_id;
455:
456: ------------------------------------------------------------
457: -- Securitized streams Cursor

Line 512: ,okl_strm_elements_v sel

508:
509: CURSOR c_src_sel(cp_stream_id IN NUMBER) IS
510: SELECT sel.source_id
511: FROM okl_bpd_ar_inv_lines_v arl
512: ,okl_strm_elements_v sel
513: WHERE arl.id = cp_stream_id
514: AND arl.sel_id = sel.id;
515:
516: