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 2613: FROM cn_comp_plans

2609: p_prefix => p_prefix);
2610:
2611: -- Check if Compensation Plan already exists in the Target Instance
2612: SELECT COUNT(name) INTO l_reuse_count
2613: FROM cn_comp_plans
2614: WHERE name = v_name_node_value_new
2615: AND org_id = p_org_id;
2616:
2617: --If Compensation Plan exits then do not Insert otherwise insert a new Record.

Line 2621: FROM cn_comp_plans

2617: --If Compensation Plan exits then do not Insert otherwise insert a new Record.
2618: IF l_reuse_count > 0 THEN
2619:
2620: SELECT status_code INTO v_comp_plan_rec.status_code
2621: FROM cn_comp_plans
2622: WHERE name = v_name_node_value_new
2623: AND org_id = p_org_id;
2624:
2625: IF v_comp_plan_rec.status_code = 'COMPLETE' THEN