DBA Data[Home] [Help]

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 2224: FROM SYS.DUAL

2220: -- check whether the plan element is already assigned to a complan
2221: BEGIN
2222: SELECT 1
2223: INTO l_temp_count
2224: FROM SYS.DUAL
2225: WHERE NOT EXISTS (SELECT 1
2226: FROM cn_quota_assigns
2227: WHERE quota_id = p_plan_element.quota_id);
2228: EXCEPTION