APPS.BIS_PMF_GET_DIMLEVELS_PVT dependencies on BSC_KPIS_B

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 2094: FROM bsc_kpis_b

2090: --//if we open up filters for AG reports.
2091:
2092: CURSOR c_kpi_cur IS
2093: SELECT indicator
2094: FROM bsc_kpis_b
2095: WHERE short_name = p_region_code;
2096:
2097:
2098: l_dimlevel_short_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;

Line 2108: l_indicator bsc_kpis_b.indicator%TYPE;

2104: l_parent_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
2105: l_restrict_all_value VARCHAR2(100);
2106:
2107: l_region_code ak_regions.region_code%TYPE;
2108: l_indicator bsc_kpis_b.indicator%TYPE;
2109: l_count NUMBER :=0;
2110:
2111: BEGIN
2112: FND_MSG_PUB.INITIALIZE;