APPS.BSC_KPI_DIM_SETS_PKG dependencies on BSC_KPI_DIM_SETS_VL

Line 193: FROM bsc_kpi_dim_sets_vl

189: ,p_Dim_Set_Id IN NUMBER
190: ) RETURN VARCHAR2 IS
191: CURSOR c_Dim_Set_Name IS
192: SELECT Name
193: FROM bsc_kpi_dim_sets_vl
194: WHERE indicator = p_Indicator
195: AND dim_set_id = p_Dim_Set_Id;
196: l_Dim_Set_Name bsc_kpi_dim_sets_vl.Name%TYPE := NULL;
197: BEGIN

Line 196: l_Dim_Set_Name bsc_kpi_dim_sets_vl.Name%TYPE := NULL;

192: SELECT Name
193: FROM bsc_kpi_dim_sets_vl
194: WHERE indicator = p_Indicator
195: AND dim_set_id = p_Dim_Set_Id;
196: l_Dim_Set_Name bsc_kpi_dim_sets_vl.Name%TYPE := NULL;
197: BEGIN
198:
199: OPEN c_Dim_Set_Name;
200: FETCH c_Dim_Set_Name INTO l_Dim_Set_Name;