APPS.CN_SYIN_ATTR_RULES_PKG dependencies on CN_HIERARCHY_NODES

Line 65: FROM cn_hierarchy_nodes hn,

61:
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