DBA Data[Home] [Help]

APPS.OKL_CO_WF dependencies on OKL_CNSLD_AR_STRMS_B

Line 1459: ,okl_cnsld_ar_strms_b ocas

1455: CURSOR l_khr_past_due_csr(cp_case_number in varchar2) IS
1456: SELECT sum(nvl(aps.amount_due_remaining, 0)) past_due_amount
1457: FROM iex_cases_all_b ica
1458: ,iex_case_objects ico
1459: ,okl_cnsld_ar_strms_b ocas
1460: ,ar_payment_schedules_all aps
1461: WHERE ica.case_number = cp_case_number
1462: AND ica.cas_id = ico.cas_id
1463: AND ico.object_id = ocas.khr_id