APPS.BSC_BIS_DIM_OBJ_PUB dependencies on BSC_KPI_DIM_LEVELS_B

Line 494: UPDATE bsc_kpi_dim_levels_b

490: AND parent_dim_level_id = p_Dim_Level_Id
491: AND relation_type = 2;
492:
493: FOR CD IN c_Relation_Col LOOP
494: UPDATE bsc_kpi_dim_levels_b
495: SET table_relation = p_Relation_Col
496: WHERE indicator = CD.indicator
497: AND dim_set_id = CD.dim_set_id
498: AND dim_level_index = CD.dim_level_index;

Line 2092: FROM BSC_KPI_DIM_LEVELS_B A

2088:
2089: CURSOR c_kpi_dim_set IS
2090: SELECT DISTINCT A.indicator Indicator
2091: , A.dim_set_id Dim_Set_Id
2092: FROM BSC_KPI_DIM_LEVELS_B A
2093: , BSC_SYS_DIM_LEVELS_B D
2094: , BSC_KPIS_B B
2095: WHERE A.Level_Table_Name = D.Level_Table_Name
2096: AND B.Indicator = A.Indicator

Line 5556: FROM BSC_KPI_DIM_LEVELS_B A

5552:
5553: CURSOR c_Kpi_Dim_Set IS
5554: SELECT DISTINCT C.Name||'['||C.Indicator||']' Name
5555: , C.Indicator
5556: FROM BSC_KPI_DIM_LEVELS_B A
5557: , BSC_SYS_DIM_LEVELS_B D
5558: , BSC_KPIS_VL C
5559: WHERE A.Level_Table_Name = D.Level_Table_Name
5560: AND D.Dim_Level_Id = l_bsc_dim_obj_rec.Bsc_Level_Id

Line 5567: FROM BSC_KPI_DIM_LEVELS_B A

5563:
5564: CURSOR c_Kpi_Dim_Set1 IS
5565: SELECT DISTINCT C.Name||'['||C.Indicator||']' Name
5566: ,C.Indicator
5567: FROM BSC_KPI_DIM_LEVELS_B A
5568: , BSC_SYS_DIM_LEVELS_B D
5569: , BSC_KPIS_VL C
5570: WHERE A.Level_Table_Name = D.Level_Table_Name
5571: AND C.share_flag <> 2

Line 6268: FROM BSC_KPI_DIM_LEVELS_B LEV,

6264: l_is_kpi_affected BOOLEAN;
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

Line 6895: FROM BSC_KPI_DIM_LEVELS_B A

6891:
6892: CURSOR c_Kpi_Dim_Set1 IS
6893: SELECT DISTINCT C.Name||'['||C.Indicator||']' Name
6894: ,C.Indicator
6895: FROM BSC_KPI_DIM_LEVELS_B A
6896: , BSC_SYS_DIM_LEVELS_B D
6897: , BSC_KPIS_VL C
6898: WHERE A.Level_Table_Name = D.Level_Table_Name
6899: AND C.share_flag <> 2

Line 6906: FROM BSC_KPI_DIM_LEVELS_B A

6902:
6903: CURSOR c_Kpi_Dim_Set IS
6904: SELECT DISTINCT C.Name||'['||C.Indicator||']' Name
6905: , C.Indicator
6906: FROM BSC_KPI_DIM_LEVELS_B A
6907: , BSC_SYS_DIM_LEVELS_B D
6908: , BSC_KPIS_VL C
6909: WHERE A.Level_Table_Name = D.Level_Table_Name
6910: AND D.Dim_Level_Id = l_bsc_dim_obj_rec.Bsc_Level_Id