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 386: l_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;

382: l_start_date DATE;
383: l_end_date DATE;
384: l_name cn_comp_plans.NAME%TYPE;
385: l_description cn_comp_plans.description%TYPE;
386: l_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;
387: l_sum_trx CN_COMP_PLANS.SUM_TRX_FLAG%TYPE;
388: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE := p_comp_plan.comp_plan_id;
389: l_loading_status VARCHAR2 (50);
390: l_return_status VARCHAR2 (50);

Line 1816: Select * from cn_comp_plans_all

1812: l_api_version CONSTANT NUMBER := 1.0;
1813:
1814:
1815: CURSOR get_comp_plan_data IS
1816: Select * from cn_comp_plans_all
1817: Where comp_plan_id = p_comp_plan_id
1818: And org_id = p_org_id;
1819:
1820: CURSOR get_quota_assign_data IS