DBA Data[Home] [Help]

APPS.BSC_DESIGNER_PVT dependencies on BSC_KPI_TREE_NODES_B

Line 300: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_TREE_NODES_B';

296: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
297:
298: --Removed this as the simulation tree tables are copied separately
299: /*g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
300: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_TREE_NODES_B';
301: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
302: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
303: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
304: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 1147: FROM BSC_KPI_TREE_NODES_B B,

1143: --
1144:
1145: CURSOR c_kpi_tree IS
1146: SELECT F.FORMAT,COLOR_METHOD
1147: FROM BSC_KPI_TREE_NODES_B B,
1148: BSC_SYS_FORMATS F
1149: WHERE INDICATOR = l_indicator AND NODE_ID = s_node
1150: AND F.FORMAT_ID = B.FORMAT_ID;
1151: CURSOR c_color_AO_DEFAULT IS