2078: WHERE short_name = cp_dimlevelSN;
2079:
2080: --/////////////////Added for Simulation Tree Enhancement for supporting filter views ////////////
2081:
2082: CURSOR c_bsc_obj_dim_level_metadata(cp_dimlevelSN IN BSC_KPI_DIM_LEVELS_VL.LEVEL_SHORTNAME%TYPE,cp_objId IN BSC_KPIS_B.INDICATOR%TYPE) IS
2083: SELECT level_pk_col
2084: ,level_view_name
2085: FROM bsc_kpi_dim_levels_vl
2086: WHERE indicator = cp_objId
2081:
2082: CURSOR c_bsc_obj_dim_level_metadata(cp_dimlevelSN IN BSC_KPI_DIM_LEVELS_VL.LEVEL_SHORTNAME%TYPE,cp_objId IN BSC_KPIS_B.INDICATOR%TYPE) IS
2083: SELECT level_pk_col
2084: ,level_view_name
2085: FROM bsc_kpi_dim_levels_vl
2086: WHERE indicator = cp_objId
2087: AND level_shortname =cp_dimlevelSN;
2088:
2089: --//Not filtering for simulation objectives,because we can use it for AG reports also