DBA Data[Home] [Help]

APPS.BSC_COMMON_DIMENSIONS_PVT dependencies on BSC_TAB_INDICATORS

Line 456: SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_Tab_Id )

452:
453: UPDATE bsc_kpi_dim_levels_b
454: SET DEFAULT_VALUE = BSC_COMMON_DIMENSIONS_PVT.C_ALL
455: WHERE indicator IN (
456: SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_Tab_Id )
457: AND default_value like BSC_COMMON_DIMENSIONS_PVT.C_COM_DIM_DEFAULT_VALUE;
458:
459: EXCEPTION
460:

Line 532: SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_Tab_Id )

528:
529: UPDATE bsc_kpi_dim_levels_b
530: SET DEFAULT_VALUE = p_default_value
531: WHERE indicator IN (
532: SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_Tab_Id )
533: AND level_table_name = l_level_table_name;
534:
535: END IF;
536: