DBA Data[Home] [Help]

APPS.BSC_BIS_DIMENSION_PUB dependencies on BSC_KPI_DIM_LEVELS_B

Line 2172: --Update BSC_KPI_DIM_LEVELS_B with the current status

2168: END IF;
2169: END IF;
2170: END IF;
2171: END LOOP;
2172: --Update BSC_KPI_DIM_LEVELS_B with the current status
2173: IF (l_kpi_cascade) THEN
2174: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet
2175: ( p_MTab_Tbl => l_MTab_Tbl
2176: , x_return_status => x_return_status

Line 3135: BSC_KPI_DIM_LEVELS_B kpi

3131:
3132: CURSOR cr_indicdimset_for_dimgrp IS
3133: SELECT grp.indicator , grp.dim_set_id,count(kpi.dim_level_index)
3134: FROM BSC_KPI_DIM_GROUPS grp,
3135: BSC_KPI_DIM_LEVELS_B kpi
3136: WHERE kpi.indicator = grp.indicator
3137: AND kpi.dim_set_id = grp.dim_set_id
3138: AND grp.dim_group_id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
3139: GROUP BY grp.indicator,grp.dim_set_id;