APPS.CN_SYIN_ATTR_RULES_PKG dependencies on CN_DIM_HIERARCHIES
Line 66: cn_dim_hierarchies dh
62: IF x_value_id IS NOT NULL THEN
63:
64: SELECT max(hn.name) INTO x_hier_value
65: FROM cn_hierarchy_nodes hn, 66: cn_dim_hierarchies dh 67: WHERE hn.value_id = to_number(x_value_id)
68: AND hn.dim_hierarchy_id = dh.dim_hierarchy_id
69: AND dh.header_dim_hierarchy_id = x_dim_hier_id
70: AND hn.org_id=dh.org_id