APPS.OKL_SUBSIDY_POOL_PVT dependencies on OKL_SUBSIDY_POOLS_V

Line 49: FROM OKL_SUBSIDY_POOLS_V

45: ,creation_date
46: ,last_updated_by
47: ,last_update_date
48: ,last_update_login
49: FROM OKL_SUBSIDY_POOLS_V
50: WHERE id = cp_pool_id;
51:
52: -------------------------------------------------------------------------------
53: -- PROCEDURE raise_business_event

Line 303: FROM okl_subsidy_pools_v

299: -------------------
300: -- cursor to fetch the effective to date of the pool id passed.
301: CURSOR c_get_to_date (cp_pool_id IN okl_subsidy_pools_b.id%type) IS
302: SELECT effective_to_date
303: FROM okl_subsidy_pools_v
304: WHERE id = cp_pool_id;
305:
306: -- Cursor to check whether the subsidies dates overlap with the subsidy pool dates.
307: CURSOR c_get_subsidy_date (cp_effective_to okl_subsidy_pools_b.effective_to_date%TYPE, cp_pool_id okl_subsidy_pools_B.id%TYPE) IS

Line 309: FROM okl_subsidy_pools_v pool, okl_subsidies_b sub

305:
306: -- Cursor to check whether the subsidies dates overlap with the subsidy pool dates.
307: CURSOR c_get_subsidy_date (cp_effective_to okl_subsidy_pools_b.effective_to_date%TYPE, cp_pool_id okl_subsidy_pools_B.id%TYPE) IS
308: SELECT 'X'
309: FROM okl_subsidy_pools_v pool, okl_subsidies_b sub
310: WHERE sub.subsidy_pool_id = pool.id
311: AND pool.id = cp_pool_id
312: AND (
313: NOT ((pool.effective_from_date BETWEEN sub.effective_from_date AND NVL(sub.effective_to_date,(TO_DATE('1','j') + 5300000)))