APPS.CN_REVENUE_CLASS_PKG dependencies on CN_HIERARCHY_NODES
Line 184: UPDATE cn_hierarchy_nodes chn
180: WHERE revenue_class_id = p_revenue_class_id;
181:
182: IF oldrow.name <> l_name THEN
183: 184: UPDATE cn_hierarchy_nodes chn 185: SET chn.name = l_name
186: WHERE chn.external_id = l_revenue_class_id
187: AND chn.dim_hierarchy_id IN (
188: select dh.dim_hierarchy_id