DBA Data[Home] [Help]

APPS.BSC_DESIGNER_PVT dependencies on BSC_KPI_TREE_NODES_TL

Line 308: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_TREE_NODES_TL';

304: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
305: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
306:
307: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
308: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_TREE_NODES_TL';
309: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
310: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
311: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
312: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

Line 903: FROM BSC_KPI_TREE_NODES_TL

899: h_a_grandparent_opt NUMBER;
900:
901: CURSOR c_kpi_tree IS
902: SELECT LANGUAGE,SOURCE_LANG,NAME
903: FROM BSC_KPI_TREE_NODES_TL
904: WHERE INDICATOR = l_indicator AND NODE_ID = s_node;
905:
906: CURSOR c_color_AO_DEFAULT IS
907: SELECT A0_DEFAULT,A1_DEFAULT,A2_DEFAULT