APPS.CN_COMP_PLANS_PKG dependencies on CN_LOOKUPS

Line 226: FROM cn_lookups lc,

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