[Home] [Help]
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
255: and cnr.id = lpt.consolidated_invoice_id
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
347: where lsm.RECEIVABLES_INVOICE_ID = l_cons_rec_inv_id