APPS.CN_COMP_PLAN_PVT dependencies on CN_COMP_PLANS_ALL

Line 60: FROM cn_comp_plans_all

56: l_num NUMBER;
57: BEGIN
58: SELECT object_version_number
59: INTO l_num
60: FROM cn_comp_plans_all
61: WHERE comp_plan_id = p_id;
62:
63: RETURN l_num;
64: END;

Line 384: l_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;

380: l_start_date DATE;
381: l_end_date DATE;
382: l_name cn_comp_plans.NAME%TYPE;
383: l_description cn_comp_plans.description%TYPE;
384: l_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;
385: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;
386: l_loading_status VARCHAR2 (50);
387: l_return_status VARCHAR2 (50);
388: l_attribute_category VARCHAR2 (150);

Line 1798: Select * from cn_comp_plans_all

1794: l_api_version CONSTANT NUMBER := 1.0;
1795:
1796:
1797: CURSOR get_comp_plan_data IS
1798: Select * from cn_comp_plans_all
1799: Where comp_plan_id = p_comp_plan_id
1800: And org_id = p_org_id;
1801:
1802: CURSOR get_quota_assign_data IS