2235:
2236: -- 2. plan element name must be unique
2237: SELECT COUNT (1)
2238: INTO l_temp_count
2239: FROM cn_quotas_all pe
2240: WHERE NAME = p_plan_element.NAME AND p_plan_element.quota_id <> pe.quota_id AND p_plan_element.org_id = pe.org_id AND delete_flag = 'N';
2241:
2242: IF l_temp_count <> 0
2243: THEN
2281:
2282: -- 2. plan element name must be unique
2283: SELECT COUNT (1)
2284: INTO l_temp_count
2285: FROM cn_quotas_all pe
2286: WHERE NAME = p_plan_element.NAME AND org_id = p_plan_element.org_id AND delete_flag = 'N';
2287:
2288: IF l_temp_count <> 0
2289: THEN