DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_QUOTAS_ALL

Line 2239: FROM cn_quotas_all pe

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

Line 2285: FROM cn_quotas_all pe

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