APPS.BSC_KPI_PUB dependencies on BSC_TAB_INDICATORS

Line 683: FROM BSC_TAB_INDICATORS

679:
680: --Determine if Indicator assigned to a tab.
681: SELECT COUNT(indicator)
682: INTO l_ind_tab_count
683: FROM BSC_TAB_INDICATORS
684: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
685:
686:
687: SELECT config_type

Line 696: FROM BSC_TAB_INDICATORS

692: -- if indicator assigned to tab get indicator.
693: IF(l_ind_tab_count > 0) THEN
694: SELECT tab_id
695: INTO l_tab_id
696: FROM BSC_TAB_INDICATORS
697: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
698: END IF;
699:
700: Get_KPI_Dim_ShortNames(l_Bsc_Kpi_Entity_Rec

Line 783: FROM BSC_TAB_INDICATORS

779:
780:
781: SELECT TAB_ID
782: INTO l_tab_id
783: FROM BSC_TAB_INDICATORS
784: WHERE INDICATOR = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
785:
786:
787: Delete_Kpi_Defaults( p_commit

Line 4736: from BSC_TAB_INDICATORS

4732:
4733: -- Get Share KPI code and Share Tab
4734: select indicator, tab_id
4735: into l_share_kpi, l_share_tab
4736: from BSC_TAB_INDICATORS
4737: where indicator in (select indicator
4738: from BSC_KPIS_B
4739: where source_indicator = l_master_kpi );
4740: -- Get Master Tab

Line 4743: from BSC_TAB_INDICATORS

4739: where source_indicator = l_master_kpi );
4740: -- Get Master Tab
4741: select tab_id
4742: into l_master_tab
4743: from BSC_TAB_INDICATORS
4744: where indicator = l_master_kpi;
4745:
4746: -- handle Metadata object
4747: UPDATE BSC_TAB_INDICATORS SET TAB_ID = l_share_tab

Line 4747: UPDATE BSC_TAB_INDICATORS SET TAB_ID = l_share_tab

4743: from BSC_TAB_INDICATORS
4744: where indicator = l_master_kpi;
4745:
4746: -- handle Metadata object
4747: UPDATE BSC_TAB_INDICATORS SET TAB_ID = l_share_tab
4748: WHERE INDICATOR= l_master_kpi;
4749: UPDATE BSC_KPI_DEFAULTS_B SET TAB_ID = l_share_tab
4750: WHERE INDICATOR = l_master_kpi;
4751: UPDATE BSC_KPI_DEFAULTS_TL SET TAB_ID = l_share_tab