APPS.OKL_SUBSIDY_POOL_RPT_PVT dependencies on OKL_SUBSIDY_POOL_BUDGETS_B

Line 306: FROM okl_subsidy_pool_budgets_b

302: SELECT budget_type_code,
303: budget_amount,
304: decision_status_code,
305: effective_from_date
306: FROM okl_subsidy_pool_budgets_b
307: WHERE subsidy_pool_id = cp_pool_id
308: AND TRUNC(effective_from_date) <= NVL(TRUNC(cp_to_date),TRUNC(effective_from_date));
309:
310: l_total_budget NUMBER ;