APPS.BSC_BIS_DIM_OBJ_PUB dependencies on BSC_KPIS_VL

Line 135: , p_Name BSC_KPIS_VL.name%TYPE

131: /*********************************************************************************/
132: TYPE KPI_Dim_Set_Type IS Record
133: ( p_kpi_id BSC_KPI_DIM_SETS_TL.indicator%TYPE
134: , p_dim_set_id BSC_KPI_DIM_SETS_TL.dim_set_id%TYPE
135: , p_Name BSC_KPIS_VL.name%TYPE
136: );
137: /*********************************************************************************/
138:
139: TYPE KPI_Dim_Set_Table_Type IS TABLE OF KPI_Dim_Set_Type INDEX BY BINARY_INTEGER;

Line 5558: , BSC_KPIS_VL C

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
5561: AND C.share_flag <> 2
5562: AND C.Indicator = A.Indicator;

Line 5569: , BSC_KPIS_VL C

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
5572: AND C.Indicator = A.Indicator
5573: AND INSTR(','||l_child_dim_obj_list||',', ','||D.dim_level_id||',') > 0;

Line 5579: , BSC_KPIS_VL B

5575: CURSOR c_Dim_Set_Kpi IS
5576: SELECT DISTINCT B.Name||'['||B.Indicator||']' Name
5577: ,B.Indicator
5578: FROM BSC_KPI_DIM_GROUPS A
5579: , BSC_KPIS_VL B
5580: , BSC_SYS_DIM_GROUPS_VL C
5581: WHERE A.INDICATOR = B.INDICATOR
5582: AND A.dim_group_id = C.Dim_Group_ID
5583: AND B.share_flag <> 2

Line 6290: FROM BSC_KPIS_VL

6286: , p_Dim_Set_Id => l_dim_set_id
6287: );
6288: IF(l_indp_dimobj >bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
6289: SELECT NAME INTO l_kpi_name
6290: FROM BSC_KPIS_VL
6291: WHERE INDICATOR = l_kpi_id;
6292:
6293: IF(l_affected_kpis IS NULL) THEN
6294: l_affected_kpis := '['||l_kpi_name||']';

Line 6897: , BSC_KPIS_VL C

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
6900: AND C.Indicator = A.Indicator
6901: AND INSTR(','||l_child_dim_obj_list||',', ','||D.dim_level_id||',') > 0;

Line 6908: , BSC_KPIS_VL C

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
6911: AND C.share_flag <> 2
6912: AND C.Indicator = A.Indicator;