2732: p_dim_obj_id IN NUMBER
2733: ) RETURN VARCHAR2
2734: IS
2735: l_parent_dim_names VARCHAR2(32000);
2736: l_name BSC_SYS_DIM_LEVELS_TL.NAME%TYPE;
2737:
2738: CURSOR c_parent_dim_level_name IS
2739: SELECT l.name name
2740: FROM BSC_SYS_DIM_LEVEL_RELS r
2773: p_dim_obj_id IN NUMBER
2774: ) RETURN VARCHAR2
2775: IS
2776: l_child_dim_names VARCHAR2(32000);
2777: l_name BSC_SYS_DIM_LEVELS_TL.NAME%TYPE;
2778:
2779: CURSOR c_child_dim_level_name IS
2780: SELECT l.name name
2781: FROM BSC_SYS_DIM_LEVEL_RELS r