APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on CN_COMP_PLANS

Line 227: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;

223: l_calc_sql_exp_id cn_calc_sql_exps.calc_sql_exp_id%TYPE;
224: l_output_exp_name cn_calc_sql_exps.name%TYPE;
225: l_f_output_exp_name cn_calc_sql_exps.name%TYPE;
226: l_perf_measure_name cn_calc_sql_exps.name%TYPE;
227: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
228: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
229: l_pmt_group_code NUMBER;
230: l_rev_class_name cn_revenue_classes.name%TYPE;
231: l_uplift_start_date DATE;

Line 2256: FROM cn_comp_plans

2252: p_prefix => p_prefix);
2253:
2254: -- Check if Compensation Plan already exists in the Target Instance
2255: SELECT COUNT(name) INTO l_reuse_count
2256: FROM cn_comp_plans
2257: WHERE name = v_name_node_value_new
2258: AND org_id = p_org_id;
2259:
2260: --If Compensation Plan exits then do not Insert otherwise insert a new Record.