DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_RPT_PVT dependencies on OKL_SUBSIDY_POOLS_V

Line 1542: FROM okl_subsidy_pools_v pool

1538: -- Cursor to fetch all the children pools of a subsidy pool entered.
1539: CURSOR get_amounts(cp_pool_id okl_subsidy_pools_b.id%TYPE) IS
1540: SELECT id ,
1541: currency_code
1542: FROM okl_subsidy_pools_v pool
1543: WHERE pool_type_code = 'BUDGET'
1544: CONNECT BY PRIOR id = subsidy_pool_id
1545: START WITH id = cp_pool_id;
1546:

Line 3766: FROM okl_subsidy_pools_v pool

3762: -- Cursor to fetch all the children pools of a subsidy pool entered.
3763: CURSOR get_amounts(cp_pool_id okl_subsidy_pools_b.id%TYPE) IS
3764: SELECT id ,
3765: currency_code
3766: FROM okl_subsidy_pools_v pool
3767: WHERE pool_type_code = 'BUDGET'
3768: CONNECT BY PRIOR id = subsidy_pool_id
3769: START WITH id = cp_pool_id;
3770: