DBA Data[Home] [Help]

APPS.OKL_LTE_INT_PVT dependencies on OKL_CNSLD_AR_LINES_B

Line 372: OKL_CNSLD_AR_LINES_B lln,

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
376: lpt.RECEIVABLES_INVOICE_ID=l_RECEIVABLES_INVOICE_ID

Line 468: , okl_cnsld_ar_lines_b lln

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
471: where lsm.RECEIVABLES_INVOICE_ID = l_cons_rec_inv_id
472: and lln.cnr_id = cnr.id