APPS.OKL_LTE_CHRG_PVT dependencies on OKL_CNSLD_AR_STRMS_V

Line 46: l_sec_rec_inv_id OKL_CNSLD_AR_STRMS_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
50: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;

Line 378: and sel.source_table = 'OKL_CNSLD_AR_STRMS_V'

374: where last.sel_id = sel.id
375: and orig.class = 'INV'
376: and orig.status = 'OP'
377: and orig.consolidated_invoice_id = sel.source_id
378: and sel.source_table = 'OKL_CNSLD_AR_STRMS_V'
379: and orig.late_charge_ass_yn = 'Y'
380: and nvl(last.late_charge_ass_yn, 'N') = 'N'
381: and orig.contract_id = last.contract_id
382: and orig.contract_id = khr.id

Line 465: cns_cons_source_table constant varchar2(25) := 'OKL_CNSLD_AR_STRMS_V';

461: cns_late_fee constant varchar2(50) := 'LATE_FEE';
462: cns_late_interest constant varchar2(50) := 'LATE_INTEREST';
463: cns_late_charge_payable constant varchar2(50) := 'INVESTOR_LATE_FEE_PAYABLE';
464: cns_AR_source_table constant varchar2(25) := 'RA_CUSTOMER_TRX_LINES_ALL';
465: cns_cons_source_table constant varchar2(25) := 'OKL_CNSLD_AR_STRMS_V';
466:
467: /* ------------------------------------------------------------
468: -- Stream Id Cursor
469: ------------------------------------------------------------