DBA Data[Home] [Help]

APPS.BSC_ANALYSIS_OPTION_PUB dependencies on BSC_KPIS_VL

Line 1215: l_Kpi_Name BSC_KPIS_VL.NAME%TYPE;

1211: , x_msg_count OUT NOCOPY NUMBER
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,

Line 1222: FROM BSC_KPIS_VL OBJ,

1218: CURSOR c_Objective_Name_Details IS
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