APPS.CNSYIN_ATTR_RULES_PKG dependencies on CN_HIERARCHY_NODES

Line 64: FROM cn_hierarchy_nodes hn,

60:
61: IF x_value_id IS NOT NULL THEN
62:
63: SELECT max(hn.name) INTO x_hier_value
64: FROM cn_hierarchy_nodes hn,
65: cn_dim_hierarchies dh
66: WHERE hn.value_id = to_number(x_value_id)
67: AND hn.dim_hierarchy_id = dh.dim_hierarchy_id
68: AND dh.header_dim_hierarchy_id = x_dim_hier_id;