APPS.BSC_MO_LOADER_CONFIG_PKG dependencies on BSC_KPI_DIM_LEVELS_B

Line 143: SELECT DISTINCT DIM_LEVEL_INDEX FROM BSC_KPI_DIM_LEVELS_B

139: l_stmt VARCHAR2(1000);
140:
141: l_level NUMBER;
142: CURSOR C1 is
143: SELECT DISTINCT DIM_LEVEL_INDEX FROM BSC_KPI_DIM_LEVELS_B
144: WHERE INDICATOR = pIndicator
145: AND DIM_SET_ID = Configuracion
146: AND STATUS <> 2
147: ORDER BY DIM_LEVEL_INDEX;

Line 582: SELECT DIM_LEVEL_INDEX FROM BSC_KPI_DIM_LEVELS_B

578:
579: l_STMT VARCHAR2(1000);
580: l_ret NUMBER := -1;
581: CURSOR C1 (p1 NUMBER, p2 NUMBER, p3 VARCHAR2) IS
582: SELECT DIM_LEVEL_INDEX FROM BSC_KPI_DIM_LEVELS_B
583: WHERE
584: INDICATOR = p1 AND
585: DIM_SET_ID = p2 AND
586: LEVEL_PK_COL = p3;