682:
683: cursor c1(p_hierarchy_id in number,
684: p_parent_level_id in number) is
685: select mhl.level_id
686: from msd_hierarchy_levels mhl
687: where mhl.hierarchy_id = p_hierarchy_id
688: and mhl.parent_level_id = p_parent_level_id;
689:
690: cursor c2 (p_dimension_code in varchar2) is
803:
804: cursor c1(p_hierarchy_id in number,
805: p_child_level_id in number) is
806: select mhl.parent_level_id
807: from msd_hierarchy_levels mhl
808: where mhl.hierarchy_id = p_hierarchy_id
809: and mhl.level_id = p_child_level_id;
810:
811: cursor c2 (p_dimension_code in varchar2) is