APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on CN_QUOTAS_V

Line 1500: FROM cn_quotas_v

1496: p_prefix => p_prefix);
1497:
1498: -- Check if Plan Element already exists in the Target Instance
1499: SELECT COUNT(name) INTO l_reuse_count
1500: FROM cn_quotas_v
1501: WHERE name = v_name_node_value_new
1502: AND org_id = p_org_id;
1503:
1504: --If Plan Element exists then do not Insert otherwise insert a new Record.

Line 2164: FROM cn_quotas_v

2160: COMMIT;
2161: -- New value of plan element for Interdependent cases
2162: g_miss_pe_exp_rec.new_pe_name := v_plan_element_rec.name;
2163: SELECT COUNT(name) INTO l_new_pe_name
2164: FROM cn_quotas_v
2165: WHERE name = v_plan_element_rec.name;
2166: IF l_new_pe_name > 0 THEN
2167: SELECT quota_id INTO g_miss_pe_exp_rec.new_pe_id
2168: FROM cn_quotas_v

Line 2168: FROM cn_quotas_v

2164: FROM cn_quotas_v
2165: WHERE name = v_plan_element_rec.name;
2166: IF l_new_pe_name > 0 THEN
2167: SELECT quota_id INTO g_miss_pe_exp_rec.new_pe_id
2168: FROM cn_quotas_v
2169: WHERE name = v_plan_element_rec.name;
2170: l_pe_counter := l_pe_counter + 1;
2171: g_miss_pe_exp_tbl(l_pe_counter).old_pe_name := g_miss_pe_exp_rec.old_pe_name;
2172: g_miss_pe_exp_tbl(l_pe_counter).old_pe_id := g_miss_pe_exp_rec.old_pe_id;

Line 2363: FROM cn_quotas_v

2359:
2360: -- Check if PE exists in the Target System
2361: l_pe_name_count := 0;
2362: SELECT count(name) INTO l_pe_name_count
2363: FROM cn_quotas_v
2364: WHERE name = v_quota_assign_tbl(i).name;
2365: IF l_pe_name_count > 0 THEN
2366: SELECT quota_id,start_date,end_date
2367: INTO v_quota_assign_tbl(i).quota_id,v_quota_assign_tbl(i).start_date, v_quota_assign_tbl(i).end_date

Line 2368: FROM cn_quotas_v

2364: WHERE name = v_quota_assign_tbl(i).name;
2365: IF l_pe_name_count > 0 THEN
2366: SELECT quota_id,start_date,end_date
2367: INTO v_quota_assign_tbl(i).quota_id,v_quota_assign_tbl(i).start_date, v_quota_assign_tbl(i).end_date
2368: FROM cn_quotas_v
2369: WHERE name = v_quota_assign_tbl(i).name
2370: AND org_id = p_org_id;
2371: ELSE
2372: ROLLBACK TO Create_CompPlan;