[Home] [Help]
926: from edw_levels_md_v lvl
927: where dim_name = p_dim
928: and not exists(
929: select 1 from
930: edw_hierarchy_level_md_v hier
931: where
932: hier.dim_name = lvl.dim_name
933: and hier.parent_lvl_id = lvl.level_id);
934:
944: from edw_levels_md_v lvl
945: where dim_id = p_dim_id
946: and not exists(
947: select 1 from
948: edw_hierarchy_level_md_v hier
949: where
950: hier.dim_name = lvl.dim_name
951: and hier.parent_lvl_id = lvl.level_id);
952: