APPS.OKL_OPI_PVT dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 1166: ,ar_receivable_applications_all ara

1162: CURSOR l_khr_last_pymt_date(cp_contract_id IN NUMBER) IS
1163: SELECT min(ara.apply_date) apply_date
1164: FROM okl_cnsld_ar_strms_b ocas
1165: ,ar_payment_schedules_all aps
1166: ,ar_receivable_applications_all ara
1167: WHERE ocas.khr_id = cp_contract_id
1168: AND ocas.receivables_invoice_id = aps.customer_trx_id
1169: AND aps.class = 'INV'
1170: AND aps.payment_schedule_id = ara.payment_schedule_id