DBA Data[Home] [Help]

APPS.OZF_QUOTA_PUB dependencies on DUAL

Line 1316: FROM DUAL;

1312: l_full_api_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1313:
1314: CURSOR product_seq_csr IS
1315: SELECT ozf_product_allocations_s.NEXTVAL
1316: FROM DUAL;
1317:
1318: CURSOR product_alloc_count_csr(p_product_alloc_id in number) IS
1319: SELECT count(p.product_allocation_id)
1320: FROM ozf_product_allocations p

Line 1362: FROM DUAL;

1358: l_full_api_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1359:
1360: CURSOR time_seq_csr IS
1361: SELECT ozf_time_allocations_s.NEXTVAL
1362: FROM DUAL;
1363:
1364: CURSOR time_alloc_count_csr(p_time_alloc_id in number) IS
1365: SELECT count(t.time_allocation_id)
1366: FROM ozf_time_allocations t

Line 1408: FROM DUAL;

1404: l_full_api_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1405:
1406: CURSOR account_seq_csr IS
1407: SELECT ozf_account_allocations_s.NEXTVAL
1408: FROM DUAL;
1409:
1410: CURSOR account_alloc_count_csr(p_account_alloc_id in number) IS
1411: SELECT count(account_allocation_id)
1412: FROM ozf_account_allocations