APPS.BSC_DIM_FILTERS_PUB dependencies on BSC_KPI_DIM_LEVELS_B

Line 402: in BSC_KPI_DIM_LEVELS_B table

398:
399: /********************************************************************************
400: Function to return Filter View Name on the basis of KPI Id and Dim Level Id.
401: This is used in cascading the data through PMD while creating new entries
402: in BSC_KPI_DIM_LEVELS_B table
403: This function will return NULL if no view exists
404: ********************************************************************************/
405: FUNCTION Get_Filter_View_Name
406: ( p_Kpi_Id IN BSC_KPIS_B.Indicator%TYPE

Line 419: l_Filter_View_Name BSC_KPI_DIM_LEVELS_B.Level_View_Name%TYPE := NULL;

415: AND B.Dim_Level_Id = p_Dim_Level_Id
416: AND B.Source_Code = A.Tab_Id
417: AND B.Source_Type = BSC_DIM_FILTERS_PUB.Source_Type_Tab;
418:
419: l_Filter_View_Name BSC_KPI_DIM_LEVELS_B.Level_View_Name%TYPE := NULL;
420: BEGIN
421: IF (c_Filter_View_Name%ISOPEN) THEN
422: CLOSE c_Filter_View_Name;
423: END IF;