APPS.BSC_BIS_DIM_REL_PUB dependencies on BSC_KPIS_VL

Line 3708: , BSC_KPIS_VL C

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

Line 3718: BSC_KPIS_VL C

3714: CURSOR c_Kpi_Dim_Set1 IS
3715: SELECT DISTINCT C.Name||'['||C.Indicator||']' Name, C.short_name
3716: FROM BSC_KPI_DIM_LEVELS_VL A,
3717: BSC_SYS_DIM_LEVELS_VL B,
3718: BSC_KPIS_VL C
3719: WHERE A.LEVEL_TABLE_NAME=B.LEVEL_TABLE_NAME
3720: AND C.INDICATOR = A.INDICATOR
3721: AND C.SHARE_FLAG <> 2
3722: AND INSTR(', '||l_final_chd_ids||',', ', '||b.dim_level_id||',') > 0;