APPS.OKL_LTE_INT_PVT dependencies on OKL_CNSLD_AR_STRMS_B

Line 167: , OKL_CNSLD_AR_STRMS_B CNSLD

163: , max(TRUNC(AR_REC.APPLY_DATE)) APPLY_DATE
164: , max('CONS-INVOICE') invoice_flag
165: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
166: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
167: , OKL_CNSLD_AR_STRMS_B CNSLD
168: , OKL_K_HEADERS_FULL_V KHR
169: , OKC_RULE_GROUPS_B RGP
170: , OKC_RULES_B RUL
171: , okc_rules_b rul_exm

Line 249: FROM OKL_CNSLD_AR_STRMS_B lsm,

245: CURSOR l_cons_lsm_cur(l_RECEIVABLES_INVOICE_ID IN NUMBER, l_khr_id in number) IS
246: SELECT lsm.id
247: , lsm.LATE_CHARGE_ASS_YN
248: , lsm.LATE_CHARGE_ASSESS_DATE
249: FROM OKL_CNSLD_AR_STRMS_B lsm,
250: OKL_CNSLD_AR_LINES_B lln,
251: OKL_CNSLD_AR_HDRS_B cnr,
252: okl_bpd_leasing_payment_trx_v lpt
253: WHERE

Line 342: from okl_cnsld_ar_strms_b lsm

338:
339: CURSOR c_sec_strm_cons_csr(l_khr_id in number, l_cons_rec_inv_id IN NUMBER ) IS
340: select lsm.id cnsld_strm_id,
341: pol.khr_id,lsm.kle_id
342: from okl_cnsld_ar_strms_b lsm
343: , okl_cnsld_ar_hdrs_b cnr
344: , okl_cnsld_ar_lines_b lln
345: , okl_pool_contents_v pk
346: , okl_pools pol

Line 958: Update okl_cnsld_ar_strms_b

954: IF l_inv_cur.INVOICE_FLAG = 'CONS-INVOICE' THEN
955: IF NOT(l_error_flag) THEN
956: FOR l_lsm IN l_cons_lsm_cur(l_inv_cur.RECEIVABLES_INVOICE_ID, l_inv_cur.CONTRACT_ID)
957: LOOP
958: Update okl_cnsld_ar_strms_b
959: set LATE_INT_ASS_YN = 'Y'
960: , LATE_INT_ASSESS_DATE = SYSDATE
961: ,last_updated_by = l_last_updated_by
962: ,last_update_date = sysdate