APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on DUAL

Line 44: FROM DUAL;

40: l_full_api_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
41:
42: CURSOR time_seq_csr IS
43: SELECT ozf_time_allocations_s.NEXTVAL
44: FROM DUAL;
45:
46: CURSOR time_alloc_count_csr(p_time_alloc_id in number) IS
47: SELECT count(t.time_allocation_id)
48: FROM ozf_time_allocations t

Line 102: FROM DUAL;

98: l_full_api_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
99:
100: CURSOR product_seq_csr IS
101: SELECT ozf_product_allocations_s.NEXTVAL
102: FROM DUAL;
103:
104: CURSOR product_alloc_count_csr(p_product_alloc_id in number) IS
105: SELECT count(p.product_allocation_id)
106: FROM ozf_product_allocations p

Line 161: FROM DUAL;

157: l_full_api_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
158:
159: CURSOR account_seq_csr IS
160: SELECT ozf_account_allocations_s.NEXTVAL
161: FROM DUAL;
162:
163: CURSOR account_alloc_count_csr(p_account_alloc_id in number) IS
164: SELECT count(account_allocation_id)
165: FROM ozf_account_allocations

Line 3339: FROM DUAL;

3335: WHERE p.allocation_for = 'FUND'
3336: AND p.allocation_for_id = l_fund_id
3337: AND p.item_id = -9999 )
3338: ) diff_target INTO l_diff_target
3339: FROM DUAL;
3340: EXCEPTION
3341: WHEN OTHERS THEN
3342: l_diff_target := 0;
3343: END;