DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_QUOTAS_ALL

Line 2263: FROM cn_quotas_all pe

2259:
2260: -- 2. plan element name must be unique
2261: SELECT COUNT (1)
2262: INTO l_temp_count
2263: FROM cn_quotas_all pe
2264: 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';
2265:
2266: IF l_temp_count <> 0
2267: THEN

Line 2309: FROM cn_quotas_all pe

2305:
2306: -- 2. plan element name must be unique
2307: SELECT COUNT (1)
2308: INTO l_temp_count
2309: FROM cn_quotas_all pe
2310: WHERE NAME = p_plan_element.NAME AND org_id = p_plan_element.org_id AND delete_flag = 'N';
2311:
2312: IF l_temp_count <> 0
2313: THEN