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 260: ,okl_strm_elements_v sel

256: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
257: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) last_arv
258: ,okl_bpd_ar_inv_lines_v orig_arl
259: ,okl_bpd_ar_inv_lines_v last_arl
260: ,okl_strm_elements_v sel
261: ,okl_k_headers_full_v khr
262: ,okc_rule_groups_b rgp
263: ,okc_rules_b rul
264: ,okc_rules_b rul_exm

Line 367: ,okl_strm_elements_v sel

363: AND CN.ID = ST.KHR_ID
364: AND LN.ID = ST.LLN_ID
365: AND HD.ID = LN.CNR_ID
366: AND SM.ID = ST.STY_ID) last
367: ,okl_strm_elements_v sel
368: ,okl_k_headers_full_v khr
369: ,okc_rule_groups_b rgp
370: ,okc_rules_b rul
371: ,okc_rules_b rul_exm

Line 514: FROM okl_strm_elements_v

510: -- Stream Element Line Number Cursor
511: ------------------------------------------------------------
512: CURSOR l_stream_line_nbr_csr(cp_stm_id IN NUMBER) IS
513: SELECT max(se_line_number) se_line_number
514: FROM okl_strm_elements_v
515: WHERE stm_id = cp_stm_id;
516:
517:
518:

Line 549: , okl_strm_elements_v sel

545: , okl_pool_contents_v pk
546: -- , okl_pools_v pol
547: , okl_pools pol
548: , ar_payment_schedules_all ps
549: , okl_strm_elements_v sel
550: where cnr.id = l_consolidated_invoice_id
551: and lln.cnr_id = cnr.id
552: and lsm.lln_id = lln.id
553: and lsm.khr_id = l_khr_id