APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_KPIS_TL

Line 5885: AND A.Indicator IN (SELECT Indicator FROM BSC_KPIS_TL WHERE Name = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Name);

5881: SELECT COUNT(indicator) INTO l_count
5882: FROM BSC_TAB_INDICATORS A
5883: WHERE A.Indicator <> p_kpi_id
5884: AND A.Tab_Id = (SELECT Tab_Id FROM BSC_TAB_INDICATORS WHERE Indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id)
5885: AND A.Indicator IN (SELECT Indicator FROM BSC_KPIS_TL WHERE Name = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Name);
5886: IF (l_count <> 0) THEN
5887: SELECT v.name
5888: INTO l_tab_name
5889: FROM bsc_tabs_vl v