DBA Data[Home] [Help]

APPS.OKL_LTE_INT_PVT dependencies on OKL_CNSLD_AR_STRMS_V

Line 31: l_khr_id OKL_CNSLD_AR_STRMS_V.KHR_ID%type;

27: l_msg_count NUMBER ;
28:
29: l_amt_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%type;
30: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;
31: l_khr_id OKL_CNSLD_AR_STRMS_V.KHR_ID%type;
32: l_apply_date AR_RECEIVABLE_APPLICATIONS_ALL.APPLY_DATE%TYPE;
33: l_cnsld_id OKL_CNSLD_AR_STRMS_V.ID%type;
34: l_amount NUMBER;
35: l_interest_amount NUMBER;

Line 33: l_cnsld_id OKL_CNSLD_AR_STRMS_V.ID%type;

29: l_amt_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%type;
30: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;
31: l_khr_id OKL_CNSLD_AR_STRMS_V.KHR_ID%type;
32: l_apply_date AR_RECEIVABLE_APPLICATIONS_ALL.APPLY_DATE%TYPE;
33: l_cnsld_id OKL_CNSLD_AR_STRMS_V.ID%type;
34: l_amount NUMBER;
35: l_interest_amount NUMBER;
36:
37: --start code pgomes 12/18/2002

Line 75: l_sec_stream_id OKL_CNSLD_AR_STRMS_V.ID%TYPE;

71:
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;

Line 286: cns_source_table constant varchar2(25) := 'OKL_CNSLD_AR_STRMS_V';

282: ------------------------------------------------------------
283: cns_late_interest constant varchar2(50) := 'LATE_INTEREST';
284: cns_late_fee constant varchar2(50) := 'LATE_FEE';
285: cns_late_interest_payable constant varchar2(50) := 'INVESTOR_LATE_INTEREST_PAY';
286: cns_source_table constant varchar2(25) := 'OKL_CNSLD_AR_STRMS_V';
287:
288: /* ------------------------------------------------------------
289: -- Stream Id Cursor
290: ------------------------------------------------------------