APPS.BSC_BIS_DIM_REL_PUB dependencies on BSC_KPI_DIM_LEVELS_B

Line 3706: FROM BSC_KPI_DIM_LEVELS_B A

3702:
3703:
3704: CURSOR c_kpi_dim_set IS
3705: SELECT DISTINCT C.Name||'['||C.Indicator||']' Name, C.short_name
3706: FROM BSC_KPI_DIM_LEVELS_B A
3707: , BSC_SYS_DIM_LEVELS_B D
3708: , BSC_KPIS_VL C
3709: WHERE A.Level_Table_Name = D.Level_Table_Name
3710: AND D.Dim_Level_Id = p_dim_obj_id

Line 4111: FROM BSC_KPI_DIM_LEVELS_B

4107: l_kpi_id := dim_objs_in_dimset(index_loop).kpi_id;
4108: l_dimset_id := dim_objs_in_dimset(index_loop).dim_set_id;
4109:
4110: SELECT COUNT(INDICATOR) INTO l_no_rels
4111: FROM BSC_KPI_DIM_LEVELS_B
4112: WHERE INDICATOR = l_kpi_id
4113: AND DIM_SET_ID = l_dimset_id
4114: AND PARENT_LEVEL_INDEX >= 0;
4115: --DBMS_OUTPUT.PUT_LINE('kpi_id :- '||l_kpi_id||'dimset_id :- '||l_dimset_id||'No of rels are :- '||l_no_rels );