DBA Data[Home] [Help]

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