DBA Data[Home] [Help]

APPS.BSC_ANALYSIS_OPTION_PUB dependencies on BSC_KPI_ANALYSIS_MEASURES_VL

Line 1216: l_Dataseries_Name BSC_KPI_ANALYSIS_MEASURES_VL.NAME%TYPE;

1212: , x_msg_data OUT NOCOPY VARCHAR2
1213: ) IS
1214: l_Kpi_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;
1215: l_Kpi_Name BSC_KPIS_VL.NAME%TYPE;
1216: l_Dataseries_Name BSC_KPI_ANALYSIS_MEASURES_VL.NAME%TYPE;
1217:
1218: CURSOR c_Objective_Name_Details IS
1219: SELECT OBJ.NAME OBJ_NAME,
1220: OBJ.SHORT_NAME SHORT_NAME,

Line 1223: BSC_KPI_ANALYSIS_MEASURES_VL DS

1219: SELECT OBJ.NAME OBJ_NAME,
1220: OBJ.SHORT_NAME SHORT_NAME,
1221: DS.NAME KPI_NAME
1222: FROM BSC_KPIS_VL OBJ,
1223: BSC_KPI_ANALYSIS_MEASURES_VL DS
1224: WHERE DS.INDICATOR = p_kpi_id
1225: AND DS.ANALYSIS_OPTION0 = p_option0
1226: AND DS.ANALYSIS_OPTION1 = p_option1
1227: AND DS.ANALYSIS_OPTION2 = p_option2