DBA Data[Home] [Help]

APPS.BIS_PMF_GET_DIMLEVELS_PVT dependencies on BSC_KPI_DIM_LEVELS_VL

Line 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

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

Line 2085: FROM bsc_kpi_dim_levels_vl

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