APPS.OKL_LTE_INT_PVT dependencies on OKL_CNSLD_AR_STRMS_B

Line 175: FROM okl_cnsld_ar_strms_b lsm

171: AND TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) < TRUNC(CRA.RECEIPT_DATE))
172: OR TRUNC(CRA.RECEIPT_DATE) IS NULL
173: OR rul_hld.rule_information1 IS NULL)
174: and not exists (SELECT 1
175: FROM okl_cnsld_ar_strms_b lsm
176: WHERE lsm.receivables_invoice_id =
177: AR_PAY.CUSTOMER_TRX_ID)
178: and ar_rec.receivable_application_id = ad.source_id
179: and ad.source_table = 'RA'

Line 250: FROM okl_cnsld_ar_strms_b lsm

246: AND TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) < TRUNC(CRA.RECEIPT_DATE))
247: OR TRUNC(CRA.RECEIPT_DATE) IS NULL
248: OR rul_hld.rule_information1 IS NULL)
249: and not exists (SELECT 1
250: FROM okl_cnsld_ar_strms_b lsm
251: WHERE lsm.receivables_invoice_id =
252: AR_PAY.CUSTOMER_TRX_ID)
253: and ar_rec.receivable_application_id = ad.source_id
254: and ad.source_table = 'RA'

Line 286: , OKL_CNSLD_AR_STRMS_B CNSLD

282: , TRUNC(CRA.RECEIPT_DATE) RECEIPT_DATE
283: , max('CONS-INVOICE') invoice_flag
284: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
285: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
286: , OKL_CNSLD_AR_STRMS_B CNSLD
287: , OKL_K_HEADERS_FULL_V KHR
288: , OKC_RULE_GROUPS_B RGP
289: , OKC_RULES_B RUL
290: , okc_rules_b rul_exm

Line 371: FROM OKL_CNSLD_AR_STRMS_B lsm,

367: CURSOR l_cons_lsm_cur(l_RECEIVABLES_INVOICE_ID IN NUMBER, l_khr_id in number) IS
368: SELECT lsm.id
369: , lsm.LATE_CHARGE_ASS_YN
370: , lsm.LATE_CHARGE_ASSESS_DATE
371: FROM OKL_CNSLD_AR_STRMS_B lsm,
372: OKL_CNSLD_AR_LINES_B lln,
373: OKL_CNSLD_AR_HDRS_B cnr,
374: okl_bpd_leasing_payment_trx_v lpt
375: WHERE

Line 466: from okl_cnsld_ar_strms_b lsm

462:
463: CURSOR c_sec_strm_cons_csr(l_khr_id in number, l_cons_rec_inv_id IN NUMBER ) IS
464: select lsm.id cnsld_strm_id,
465: pol.khr_id,lsm.kle_id
466: from okl_cnsld_ar_strms_b lsm
467: , okl_cnsld_ar_hdrs_b cnr
468: , okl_cnsld_ar_lines_b lln
469: , okl_pool_contents_v pk
470: , okl_pools pol

Line 1095: Update okl_cnsld_ar_strms_b

1091: IF l_inv_cur.INVOICE_FLAG = 'CONS-INVOICE' THEN
1092: IF NOT(l_error_flag) THEN
1093: FOR l_lsm IN l_cons_lsm_cur(l_inv_cur.RECEIVABLES_INVOICE_ID, l_inv_cur.CONTRACT_ID)
1094: LOOP
1095: Update okl_cnsld_ar_strms_b
1096: set LATE_INT_ASS_YN = 'Y'
1097: , LATE_INT_ASSESS_DATE = SYSDATE
1098: ,last_updated_by = l_last_updated_by
1099: ,last_update_date = sysdate