DBA Data[Home] [Help]

APPS.BSC_DESIGNER_PVT dependencies on BSC_KPI_ANALYSIS_GROUPS

Line 76: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_GROUPS';

72: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
73: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
74:
75: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
76: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_GROUPS';
77: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
78: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
79: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
80: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 924: FROM BSC_KPI_ANALYSIS_GROUPS

920:
921: --bug#2740431, check dependency between analysis groups
922: CURSOR c_kpi_group_dependency IS
923: SELECT ANALYSIS_GROUP_ID,DEPENDENCY_FLAG
924: FROM BSC_KPI_ANALYSIS_GROUPS
925: WHERE INDICATOR = l_indicator;
926:
927:
928: h_msg VARCHAR2(1000);