APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_KPI_ANALYSIS_OPTIONS_B

Line 6440: This will be populated as the SHORT_NAME to the table BSC_KPI_ANALYSIS_OPTIONS_B

6436:
6437:
6438: /*
6439: Returns the region code that will be associated with the next Analysis Option
6440: This will be populated as the SHORT_NAME to the table BSC_KPI_ANALYSIS_OPTIONS_B
6441:
6442: This API is specific to Start-to-End KPI, do not use it when we have Multiple AO Groups.
6443: */
6444: FUNCTION Get_Next_Region_Code_By_AO (

Line 6459: FROM BSC_KPI_ANALYSIS_OPTIONS_B

6455: l_Count := 0;
6456:
6457: SELECT (NVL(MAX(OPTION_ID), -1)+1)
6458: INTO l_Next_Analysis_Option
6459: FROM BSC_KPI_ANALYSIS_OPTIONS_B
6460: WHERE INDICATOR = p_Kpi_Id
6461: AND ANALYSIS_GROUP_ID = NVL(p_Analysis_Group0, 0);
6462:
6463:

Line 6506: FROM BSC_KPI_ANALYSIS_OPTIONS_B

6502: END IF;
6503:
6504: SELECT DISTINCT INDICATOR
6505: INTO l_Kpi_Id
6506: FROM BSC_KPI_ANALYSIS_OPTIONS_B
6507: WHERE SHORT_NAME = (SELECT SUBSTR(ACTUAL_DATA_SOURCE, 1, INSTR(ACTUAL_DATA_SOURCE, '.') - 1) REGION_CODE
6508: FROM BIS_INDICATORS
6509: WHERE SHORT_NAME = p_Short_Name);
6510:

Line 7073: FROM BSC_KPI_ANALYSIS_OPTIONS_B

7069:
7070: -- short_name now stores the AK Region codes for the Objective AOs
7071: CURSOR c_Regions IS
7072: SELECT SHORT_NAME
7073: FROM BSC_KPI_ANALYSIS_OPTIONS_B
7074: WHERE INDICATOR = l_Kpi_Id;
7075:
7076: BEGIN
7077:

Line 9125: BSC_KPI_ANALYSIS_OPTIONS_B A

9121:
9122: SELECT COUNT(1) INTO l_Count
9123: FROM BSC_TABS_B T,
9124: BSC_TAB_INDICATORS K,
9125: BSC_KPI_ANALYSIS_OPTIONS_B A
9126: WHERE T.TAB_ID = p_Tab_id
9127: AND K.TAB_ID = T.TAB_ID
9128: AND A.INDICATOR = K.INDICATOR
9129: AND A.SHORT_NAME = T.SHORT_NAME;