DBA Data[Home] [Help]

APPS.OKL_LTE_INT_PVT dependencies on OKL_CNSLD_AR_LINES_B

Line 250: OKL_CNSLD_AR_LINES_B lln,

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

Line 344: , okl_cnsld_ar_lines_b lln

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