APPS.CN_PLAN_ELEMENT_PVT dependencies on DUAL

Line 109: FROM DUAL

105: THEN
106: BEGIN
107: SELECT 1
108: INTO l_dummy
109: FROM DUAL
110: WHERE EXISTS (SELECT 1
111: FROM cn_quotas_v
112: WHERE quota_id = p_quota_id AND org_id = p_org_id);
113: EXCEPTION

Line 1412: FROM DUAL;

1408: IF p_plan_element.quota_id IS NULL
1409: THEN
1410: SELECT cn_quotas_s.NEXTVAL
1411: INTO p_plan_element.quota_id
1412: FROM DUAL;
1413: END IF;
1414:
1415: -- validate plan element
1416: validate_plan_element (p_api_version => p_api_version,

Line 2200: FROM SYS.DUAL

2196: -- check whether the plan element is already assigned to a complan
2197: BEGIN
2198: SELECT 1
2199: INTO l_temp_count
2200: FROM SYS.DUAL
2201: WHERE NOT EXISTS (SELECT 1
2202: FROM cn_quota_assigns
2203: WHERE quota_id = p_plan_element.quota_id);
2204: EXCEPTION