APPS.OKL_LTE_INT_PVT dependencies on OKL_BPD_AR_INV_LINES_V

Line 107: , OKL_BPD_AR_INV_LINES_V ARL

103: , max(TRUNC(AR_REC.APPLY_DATE)) APPLY_DATE
104: ,max('AR-INVOICE') invoice_flag
105: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
106: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
107: , OKL_BPD_AR_INV_LINES_V ARL
108: , OKL_K_HEADERS_FULL_V KHR
109: , OKC_RULE_GROUPS_B RGP
110: , OKC_RULES_B RUL
111: , okc_rules_b rul_exm

Line 267: FROM OKL_BPD_AR_INV_LINES_V

263: CURSOR l_AR_lsm_cur(l_id IN NUMBER,l_contract_id in number) IS
264: SELECT ID
265: , LATE_CHARGE_ASS_YN
266: , LATE_CHARGE_ASSESS_DATE
267: FROM OKL_BPD_AR_INV_LINES_V
268: WHERE RECEIVABLES_INVOICE_ID = l_id
269: AND CONTRACT_ID=l_contract_id
270: FOR UPDATE OF LATE_CHARGE_ASS_YN, LATE_CHARGE_ASSESS_DATE;
271:

Line 363: FROM okl_bpd_ar_inv_lines_v arl

359:
360: CURSOR c_sec_strm_AR_csr(cp_contract_id in number, cp_con_rec_inv_id IN VARCHAR2) IS
361: SELECT arl.id cnsld_strm_id
362: ,pol.khr_id, pk.kle_id kle_id
363: FROM okl_bpd_ar_inv_lines_v arl
364: ,okl_bpd_ar_invoices_v arv
365: ,okl_pool_contents_v pk
366: ,okl_pools pol
367: WHERE arl.RECEIVABLES_INVOICE_ID = cp_con_rec_inv_id

Line 387: FROM okl_bpd_ar_inv_lines_v arl

383: --Modified data elements, view name, where clause
384:
385: CURSOR c_src_sel(cp_stream_id IN NUMBER) IS
386: SELECT sel.source_id
387: FROM okl_bpd_ar_inv_lines_v arl
388: ,okl_strm_elements_v sel
389: WHERE arl.id = cp_stream_id
390: AND arl.sel_id = sel.id;
391: