APPS.OKL_LTE_INT_PVT dependencies on OKL_BPD_AR_INV_LINES_V

Line 389: FROM OKL_BPD_AR_INV_LINES_V

385: CURSOR l_AR_lsm_cur(l_id IN NUMBER,l_contract_id in number) IS
386: SELECT ID
387: , LATE_CHARGE_ASS_YN
388: , LATE_CHARGE_ASSESS_DATE
389: FROM OKL_BPD_AR_INV_LINES_V
390: WHERE RECEIVABLES_INVOICE_ID = l_id
391: AND CONTRACT_ID=l_contract_id
392: FOR UPDATE OF LATE_CHARGE_ASS_YN, LATE_CHARGE_ASSESS_DATE;
393:

Line 487: FROM okl_bpd_ar_inv_lines_v arl

483:
484: CURSOR c_sec_strm_AR_csr(cp_contract_id in number, cp_con_rec_inv_id IN VARCHAR2) IS
485: SELECT arl.id cnsld_strm_id
486: ,pol.khr_id, pk.kle_id kle_id
487: FROM okl_bpd_ar_inv_lines_v arl
488: ,okl_bpd_ar_invoices_v arv
489: ,okl_pool_contents_v pk
490: ,okl_pools pol
491: WHERE arl.RECEIVABLES_INVOICE_ID = cp_con_rec_inv_id

Line 511: FROM okl_bpd_ar_inv_lines_v arl

507: --Modified data elements, view name, where clause
508:
509: CURSOR c_src_sel(cp_stream_id IN NUMBER) IS
510: SELECT sel.source_id
511: FROM okl_bpd_ar_inv_lines_v arl
512: ,okl_strm_elements_v sel
513: WHERE arl.id = cp_stream_id
514: AND arl.sel_id = sel.id;
515: