[Home] [Help]
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