DBA Data[Home] [Help]

APPS.BSC_SIMULATION_VIEW_PVT dependencies on BSC_KPI_TREE_NODES_TL

Line 174: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_KPI_TREE_NODES_TL';

170: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
171:
172:
173: x_Table_Number := x_Table_Number + 1;
174: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_KPI_TREE_NODES_TL';
175: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_KPI_TABLE ;
176: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_INDICATOR ;
177: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
178: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;

Line 674: UPDATE bsc_kpi_tree_nodes_tl

670: SET node_id =l_dataset_id
671: WHERE indicator =p_target_kpi
672: AND node_id =l_link_id;
673:
674: UPDATE bsc_kpi_tree_nodes_tl
675: SET node_id =l_dataset_id
676: WHERE indicator =p_target_kpi
677: AND node_id =l_link_id;
678: END IF;