APPS.BSC_DESIGNER_PVT dependencies on BSC_KPI_DIM_LEVELS_VL

Line 1446: FROM BSC_KPI_DIM_LEVELS_VL VL,

1442: h_tmp VARCHAR2(270); /* Bug Fix #2691601 changine size from 80 to 255 */
1443: h_tmp1 VARCHAR2(270); /* Bug Fix #2691601 changine size from 80 to 255 */
1444: CURSOR c_kpi_dim IS
1445: SELECT VL.DIM_SET_ID,VL.DIM_LEVEL_INDEX, VL.LEVEL_VIEW_NAME,VL.VALUE_ORDER_BY
1446: FROM BSC_KPI_DIM_LEVELS_VL VL,
1447: BSC_KPI_DEFAULTS_B DF
1448: WHERE VL.INDICATOR =l_indicator
1449: AND VL.INDICATOR = DF.INDICATOR
1450: AND VL.DIM_SET_ID = DF.DIM_SET_ID

Line 1475: FROM BSC_KPI_DIM_LEVELS_VL

1471: B.DIM_LEVEL_INDEX = h_drill;
1472: --Set text for key item
1473: CURSOR c_key_item IS
1474: SELECT DIM_SET_ID,DIM_LEVEL_INDEX,LEVEL_TABLE_NAME,DEFAULT_KEY_VALUE
1475: FROM BSC_KPI_DIM_LEVELS_VL
1476: WHERE INDICATOR=l_indicator
1477: AND DEFAULT_KEY_VALUE>0
1478: AND DIM_LEVEL_INDEX<8;
1479:

Line 2430: FROM BSC_KPI_DIM_LEVELS_VL) DIM

2426: CURSOR c_dimset IS
2427: SELECT DFT.INDICATOR
2428: FROM BSC_DB_COLOR_KPI_V DFT,
2429: (SELECT DISTINCT INDICATOR,DIM_SET_ID,NVL(LEVEL_SOURCE,'BSC') SOURCE
2430: FROM BSC_KPI_DIM_LEVELS_VL) DIM
2431: WHERE DFT.INDICATOR = DIM .INDICATOR
2432: AND DFT.DIM_SET_ID = DIM .DIM_SET_ID
2433: AND DFT.TAB_ID = x_Tab_id
2434: AND DIM.SOURCE ='PMF';