APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_COMP_PLANS

Line 2656: l_plan_name cn_comp_plans.NAME%TYPE;

2652: recinfo rt_quota_asgns_curs%ROWTYPE;
2653: x_formula_name cn_calc_formulas.NAME%TYPE;
2654: x_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
2655: l_tmp NUMBER;
2656: l_plan_name cn_comp_plans.NAME%TYPE;
2657: l_plan_element plan_element_rec_type;
2658: g_incomplete VARCHAR2 (30) := 'INCOMPLETE';
2659: g_complete VARCHAR2 (30) := 'COMPLETE';
2660: l_temp_status_code VARCHAR2 (30) := g_complete;

Line 2702: FROM cn_comp_plans

2698: IF p_comp_plan_id IS NOT NULL
2699: THEN
2700: SELECT NAME
2701: INTO l_plan_name
2702: FROM cn_comp_plans
2703: WHERE comp_plan_id = p_comp_plan_id;
2704: END IF;
2705:
2706: SELECT cf.NAME,