APPS.OKL_LTE_CHRG_PVT dependencies on OKL_STRM_TYPE_V

Line 40: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;

36: l_rec_inv_contract_id NUMBER;
37: l_amt_due_remaining AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%type;
38: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;
39: l_khr_id OKL_CNSLD_AR_STRMS_B.KHR_ID%type;
40: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;
41: l_stm_id OKL_STREAMS_V.ID%TYPE;
42: l_late_stm_id OKL_STREAMS_V.ID%TYPE;
43: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
44: l_amount NUMBER;

Line 45: l_stream_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;

41: l_stm_id OKL_STREAMS_V.ID%TYPE;
42: l_late_stm_id OKL_STREAMS_V.ID%TYPE;
43: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
44: l_amount NUMBER;
45: l_stream_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
46: l_sec_rec_inv_id OKL_CNSLD_AR_STRMS_V.ID%TYPE;
47: l_error_flag BOOLEAN := FALSE;
48:
49: --start code pgomes 12/18/2002

Line 476: SELECT id FROM okl_strm_type_v where name = cp_name;

472: /* ------------------------------------------------------------
473: -- Stream Id Cursor
474: ------------------------------------------------------------
475: CURSOR l_sty_id_cur(cp_name IN VARCHAR2) IS
476: SELECT id FROM okl_strm_type_v where name = cp_name;
477: */
478: ------------------------------------------------------------
479: -- Stream Cursor
480: ------------------------------------------------------------