DBA Data[Home] [Help]

APPS.BSC_BIS_DIM_OBJ_PUB dependencies on BSC_KPI_DIM_LEVEL_PROPERTIES

Line 5798: ,BSC_KPI_DIM_LEVEL_PROPERTIES KDL

5794:
5795: CURSOR cr_dimobj_in_dimset IS
5796: SELECT B.SHORT_NAME
5797: FROM BSC_SYS_DIM_LEVELS_B B
5798: ,BSC_KPI_DIM_LEVEL_PROPERTIES KDL
5799: WHERE B.DIM_LEVEL_ID = KDL.DIM_LEVEL_ID
5800: AND KDL.indicator = l_kpi_id
5801: AND KDL.dim_set_id = l_dim_set_id;
5802:

Line 6269: BSC_KPI_DIM_LEVEL_PROPERTIES prop

6265:
6266: CURSOR cr_kpi_dimset_dimobj IS
6267: SELECT LEV.INDICATOR,LEV.dim_set_id,COUNT(LEV.dim_level_index)
6268: FROM BSC_KPI_DIM_LEVELS_B LEV,
6269: BSC_KPI_DIM_LEVEL_PROPERTIES prop
6270: WHERE lev.INDICATOR = prop.INDICATOR
6271: AND lev.dim_Set_id = prop.dim_set_id
6272: AND prop.dim_level_id = p_dim_id
6273: GROUP BY lev.INDICATOR,lev.dim_set_id;