APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_COMP_PLANS

Line 2632: l_plan_name cn_comp_plans.NAME%TYPE;

2628: recinfo rt_quota_asgns_curs%ROWTYPE;
2629: x_formula_name cn_calc_formulas.NAME%TYPE;
2630: x_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
2631: l_tmp NUMBER;
2632: l_plan_name cn_comp_plans.NAME%TYPE;
2633: l_plan_element plan_element_rec_type;
2634: g_incomplete VARCHAR2 (30) := 'INCOMPLETE';
2635: g_complete VARCHAR2 (30) := 'COMPLETE';
2636: l_temp_status_code VARCHAR2 (30) := g_complete;

Line 2678: FROM cn_comp_plans

2674: IF p_comp_plan_id IS NOT NULL
2675: THEN
2676: SELECT NAME
2677: INTO l_plan_name
2678: FROM cn_comp_plans
2679: WHERE comp_plan_id = p_comp_plan_id;
2680: END IF;
2681:
2682: SELECT cf.NAME,