APPS.OKL_LTE_CHRG_PVT dependencies on OKL_CNSLD_AR_HDRS_B

Line 174: ,OKL_CNSLD_AR_HDRS_B HD

170: ,sum(PS.amount_due_remaining) amount_due_remaining
171: ,PS.due_date
172: from AR_PAYMENT_SCHEDULES_ALL PS
173: ,OKL_CNSLD_AR_STRMS_B ST
174: ,OKL_CNSLD_AR_HDRS_B HD
175: ,OKC_K_HEADERS_ALL_B CN
176: ,OKL_CNSLD_AR_LINES_B LN
177: ,OKL_STRM_TYPE_B SM
178: ,okl_k_headers_full_v khr

Line 337: OKL_CNSLD_AR_HDRS_B HD,

333: SM.ID STREAM_TYPE_ID,
334: PS.STATUS STATUS
335: FROM AR_PAYMENT_SCHEDULES_ALL PS,
336: OKL_CNSLD_AR_STRMS_B ST,
337: OKL_CNSLD_AR_HDRS_B HD,
338: OKC_K_HEADERS_ALL_B CN,
339: OKL_CNSLD_AR_LINES_B LN,
340: OKL_STRM_TYPE_B SM
341: WHERE PS.CLASS IN ('INV', 'CM')

Line 362: OKL_CNSLD_AR_HDRS_B HD,

358: SM.ID STREAM_TYPE_ID,
359: PS.STATUS STATUS
360: FROM AR_PAYMENT_SCHEDULES_ALL PS,
361: OKL_CNSLD_AR_STRMS_B ST,
362: OKL_CNSLD_AR_HDRS_B HD,
363: OKC_K_HEADERS_ALL_B CN,
364: OKL_CNSLD_AR_LINES_B LN,
365: OKL_STRM_TYPE_B SM
366: WHERE PS.CLASS IN ('INV', 'CM')

Line 438: OKL_CNSLD_AR_HDRS_B cnr

434: , LATE_CHARGE_ASS_YN
435: , LATE_CHARGE_ASSESS_DATE
436: FROM OKL_CNSLD_AR_STRMS_B lsm,
437: OKL_CNSLD_AR_LINES_B lln,
438: OKL_CNSLD_AR_HDRS_B cnr
439: WHERE cnr.id = l_consolidated_invoice_id
440: and lln.cnr_id = cnr.id
441: and lsm.lln_id = lln.id
442: and lsm.KHR_ID = l_khr_id

Line 548: , okl_cnsld_ar_hdrs_b cnr

544: CURSOR c_sec_strm_cons_csr(l_consolidated_invoice_id IN NUMBER, l_khr_id in number) IS
545: select lsm.id cnsld_strm_id, pol.khr_id, ps.amount_due_remaining,lsm.kle_id
546: from
547: okl_cnsld_ar_strms_b lsm
548: , okl_cnsld_ar_hdrs_b cnr
549: , okl_cnsld_ar_lines_b lln
550: , okl_pool_contents_v pk
551: -- , okl_pools_v pol
552: , okl_pools pol