eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SUBSIDY_POOL_PVT dependencies on OKL_SUBSIDIES_B

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)))