APPS.CN_QUOTA_ASSIGN_PUB dependencies on CN_COMP_PLANS

Line 34: FROM cn_comp_plans

30: function validate_cp_name(p_cp_name varchar2,p_org_id number) RETURN number IS
31: l_cp_id number := 0;
32: CURSOR l_cp_id_csr(p_plan_name varchar2) IS
33: SELECT comp_plan_id
34: FROM cn_comp_plans
35: WHERE name = p_plan_name
36: and org_id = p_org_id;
37: BEGIN
38: OPEN l_cp_id_csr(p_cp_name);