APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_TAB_INDICATORS

Line 5429: FROM BSC_TAB_INDICATORS

5425: RAISE FND_API.G_EXC_ERROR;
5426: END IF;
5427: --Determine if Indicator assigned to a tab.
5428: SELECT COUNT(indicator) INTO l_count
5429: FROM BSC_TAB_INDICATORS
5430: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5431: -- if indicator assigned to tab get tab id.
5432: IF(l_count > 0) THEN
5433: SELECT tab_id INTO l_tab_id

Line 5434: FROM BSC_TAB_INDICATORS

5430: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5431: -- if indicator assigned to tab get tab id.
5432: IF(l_count > 0) THEN
5433: SELECT tab_id INTO l_tab_id
5434: FROM BSC_TAB_INDICATORS
5435: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5436: END IF;
5437: -- obtain dimension set id this option is using.
5438: SELECT dim_set_id INTO l_dim_set_id

Line 5660: FROM BSC_TAB_INDICATORS

5656: END IF;
5657:
5658: --Determine if Indicator assigned to a tab.
5659: SELECT COUNT(indicator) INTO l_count
5660: FROM BSC_TAB_INDICATORS
5661: WHERE indicator = p_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5662: -- if indicator assigned to tab get tab id.
5663: IF(l_count > 0) THEN
5664: SELECT tab_id INTO l_tab_id

Line 5665: FROM BSC_TAB_INDICATORS

5661: WHERE indicator = p_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5662: -- if indicator assigned to tab get tab id.
5663: IF(l_count > 0) THEN
5664: SELECT tab_id INTO l_tab_id
5665: FROM BSC_TAB_INDICATORS
5666: WHERE indicator = p_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5667: END IF;
5668: -- Need to call procedure for list button logic.
5669: BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels

Line 5882: FROM BSC_TAB_INDICATORS A

5878: -- We need to check if there is an update on the Indicator name in order
5879: -- to prevent it. To do this we need to check if there is a different
5880: -- indicator in the same tab with the same 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

Line 5884: AND A.Tab_Id = (SELECT Tab_Id FROM BSC_TAB_INDICATORS WHERE Indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id)

5880: -- indicator in the same tab with the same 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

Line 5890: ,bsc_tab_indicators w

5886: IF (l_count <> 0) THEN
5887: SELECT v.name
5888: INTO l_tab_name
5889: FROM bsc_tabs_vl v
5890: ,bsc_tab_indicators w
5891: WHERE v.tab_id =w.tab_id
5892: AND w.indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5893:
5894: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');

Line 8075: FROM bsc_tab_indicators

8071: )
8072: IS
8073: CURSOR c_objective_tabs(p_indicator NUMBER) IS
8074: SELECT DISTINCT tab_id
8075: FROM bsc_tab_indicators
8076: WHERE indicator = p_indicator;
8077:
8078: CURSOR c_common_dim(p_tab_id NUMBER, p_dim VARCHAR2) IS
8079: SELECT 1