APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on DUAL

Line 63: FROM DUAL;

59: l_full_api_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
60:
61: CURSOR time_seq_csr IS
62: SELECT ozf_time_allocations_s.NEXTVAL
63: FROM DUAL;
64:
65: CURSOR time_alloc_count_csr(p_time_alloc_id in number) IS
66: SELECT count(t.time_allocation_id)
67: FROM ozf_time_allocations t

Line 121: FROM DUAL;

117: l_full_api_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
118:
119: CURSOR product_seq_csr IS
120: SELECT ozf_product_allocations_s.NEXTVAL
121: FROM DUAL;
122:
123: CURSOR product_alloc_count_csr(p_product_alloc_id in number) IS
124: SELECT count(p.product_allocation_id)
125: FROM ozf_product_allocations p

Line 180: FROM DUAL;

176: l_full_api_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
177:
178: CURSOR account_seq_csr IS
179: SELECT ozf_account_allocations_s.NEXTVAL
180: FROM DUAL;
181:
182: CURSOR account_alloc_count_csr(p_account_alloc_id in number) IS
183: SELECT count(account_allocation_id)
184: FROM ozf_account_allocations

Line 3364: FROM DUAL;

3360: WHERE p.allocation_for = 'FUND'
3361: AND p.allocation_for_id = l_fund_id
3362: AND p.item_id = -9999 )
3363: ) diff_target INTO l_diff_target
3364: FROM DUAL;
3365: EXCEPTION
3366: WHEN OTHERS THEN
3367: l_diff_target := 0;
3368: END;