APPS.CN_SRP_PLAN_ASSIGNS_PKG dependencies on CN_COMP_PLANS_ALL

Line 123: FROM cn_comp_plans_all

119: Get_UID(X_SRP_PLAN_ASSIGN_ID);
120:
121: -- get org ID
122: SELECT org_id INTO l_org_id
123: FROM cn_comp_plans_all
124: WHERE comp_plan_id = x_comp_plan_id;
125:
126: INSERT INTO CN_SRP_PLAN_ASSIGNS
127: (SRP_PLAN_ASSIGN_ID,