APPS.OKL_LTE_CHRG_PVT dependencies on OKL_STRM_ELEMENTS_V

Line 43: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%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;
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;

Line 65: l_late_charge_amt okl_strm_elements_v.amount%TYPE;

61: l_late_chrg_fixed_yn okl_late_policies_v.late_chrg_fixed_yn%TYPE;
62: l_late_chrg_allowed_yn okl_late_policies_v.late_chrg_allowed_yn%TYPE;
63: l_late_chrg_rate okl_late_policies_v.late_chrg_rate%TYPE;
64:
65: l_late_charge_amt okl_strm_elements_v.amount%TYPE;
66:
67: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
68: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
69: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;

Line 87: l_sel_id Okl_strm_elements_v.sel_id%TYPE;

83:
84: l_selv_rec Okl_Sel_Pvt.selv_rec_type;
85: lx_selv_rec Okl_Sel_Pvt.selv_rec_type;
86: l_init_selv_rec Okl_Sel_Pvt.selv_rec_type;
87: l_sel_id Okl_strm_elements_v.sel_id%TYPE;
88: l_prev_khr_id okl_k_headers.id%TYPE; --dkagrawa added for bug# 4728636
89:
90: --vdamerla bug 5474844
91: l_investor_disb_flag varchar2(1);

Line 265: ,okl_strm_elements_v sel

261: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
262: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) last_arv
263: ,okl_bpd_ar_inv_lines_v orig_arl
264: ,okl_bpd_ar_inv_lines_v last_arl
265: ,okl_strm_elements_v sel
266: ,okl_k_headers_full_v khr
267: ,okc_rule_groups_b rgp
268: ,okc_rules_b rul
269: ,okc_rules_b rul_exm

Line 372: ,okl_strm_elements_v sel

368: AND CN.ID = ST.KHR_ID
369: AND LN.ID = ST.LLN_ID
370: AND HD.ID = LN.CNR_ID
371: AND SM.ID = ST.STY_ID) last
372: ,okl_strm_elements_v sel
373: ,okl_k_headers_full_v khr
374: ,okc_rule_groups_b rgp
375: ,okc_rules_b rul
376: ,okc_rules_b rul_exm

Line 519: FROM okl_strm_elements_v

515: -- Stream Element Line Number Cursor
516: ------------------------------------------------------------
517: CURSOR l_stream_line_nbr_csr(cp_stm_id IN NUMBER) IS
518: SELECT max(se_line_number) se_line_number
519: FROM okl_strm_elements_v
520: WHERE stm_id = cp_stm_id;
521:
522:
523:

Line 554: , okl_strm_elements_v sel

550: , okl_pool_contents_v pk
551: -- , okl_pools_v pol
552: , okl_pools pol
553: , ar_payment_schedules_all ps
554: , okl_strm_elements_v sel
555: where cnr.id = l_consolidated_invoice_id
556: and lln.cnr_id = cnr.id
557: and lsm.lln_id = lln.id
558: and lsm.khr_id = l_khr_id