APPS.BSC_BIS_DIM_REL_PUB dependencies on BSC_KPI_DIM_LEVELS_VL

Line 510: ' , BSC_KPI_DIM_LEVELS_VL C '||

506: l_Sql := ' SELECT DISTINCT A.TAB_ID '||
507: ' FROM ' ||
508: ' BSC_TABS_VL A '||
509: ' , BSC_TAB_INDICATORS B '||
510: ' , BSC_KPI_DIM_LEVELS_VL C '||
511: ' , BSC_SYS_DIM_LEVELS_VL D '||
512: ' WHERE A.TAB_ID =B.TAB_ID '||
513: ' AND B.INDICATOR =C.INDICATOR '||
514: ' AND C.LEVEL_TABLE_NAME = D.LEVEL_TABLE_NAME '||

Line 1521: FROM BSC_KPI_DIM_LEVELS_VL A,

1517: CURSOR c_Kpi_Dim_Set IS
1518: SELECT DISTINCT A.INDICATOR Indicator,
1519: A.DIM_SET_ID Dim_Set_Id,
1520: C.short_name
1521: FROM BSC_KPI_DIM_LEVELS_VL A,
1522: BSC_SYS_DIM_LEVELS_VL B,
1523: BSC_KPIS_B C
1524: WHERE A.LEVEL_TABLE_NAME=B.LEVEL_TABLE_NAME
1525: AND C.INDICATOR = A.INDICATOR

Line 3716: FROM BSC_KPI_DIM_LEVELS_VL A,

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