APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BIS_INDICATORS

Line 8019: l_actual_data_source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;

8015: , p_Dim_Obj_Short_Name IN VARCHAR2
8016: , p_Property_Type IN VARCHAR2
8017: ) RETURN VARCHAR2 IS
8018: l_region_code AK_REGIONS.REGION_CODE%TYPE;
8019: l_actual_data_source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
8020: l_DimObj_ViewBy_Tbl BIS_PMV_BSC_API_PUB.DimLevel_Viewby_Tbl_Type;
8021: l_return_status VARCHAR2(100);
8022: l_msg_data VARCHAR2(2000);
8023: l_msg_count NUMBER;

Line 8029: FROM BIS_INDICATORS

8025: BEGIN
8026: IF (p_Measure_Short_Name IS NOT NULL AND p_Dim_Obj_Short_Name IS NOT NULL) THEN
8027: SELECT actual_data_source
8028: INTO l_actual_data_source
8029: FROM BIS_INDICATORS
8030: WHERE SHORT_NAME = p_Measure_Short_Name;
8031: l_region_code := SUBSTR(l_actual_data_source, 0, (INSTR(l_actual_data_source,'.')-1));
8032: IF(l_region_code IS NOT NULL) THEN
8033: BIS_PMV_BSC_API_PUB.Get_Dimlevel_Viewby