APPS.CN_COMP_PLANS_PKG dependencies on CN_LOOKUPS

Line 227: FROM cn_lookups lc,

223: SELECT lc.meaning
224: ,lc.lookup_code
225: INTO X_Status
226: ,X_status_code
227: FROM cn_lookups lc,
228: cn_comp_plans cp
229: WHERE cp.status_code = lc.lookup_code
230: AND lc.lookup_type = 'PLAN_OBJECT_STATUS'
231: AND cp.comp_plan_id = x_comp_plan_id