DBA Data[Home] [Help]

APPS.OKL_LTE_INT_PVT dependencies on OKL_CNSLD_AR_HDRS_B

Line 373: OKL_CNSLD_AR_HDRS_B cnr,

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
377: and cnr.id = lpt.consolidated_invoice_id

Line 467: , okl_cnsld_ar_hdrs_b cnr

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
471: where lsm.RECEIVABLES_INVOICE_ID = l_cons_rec_inv_id