APPS.BSC_DIM_FILTERS_PUB dependencies on BSC_KPIS_B

Line 120: ( p_Kpi_Id IN BSC_KPIS_B.Indicator%TYPE

116: RAISE;
117: END Check_Filters_Not_Apply;
118:
119: PROCEDURE Check_Filters_Not_Apply_By_KPI
120: ( p_Kpi_Id IN BSC_KPIS_B.Indicator%TYPE
121: , x_return_status OUT NOCOPY VARCHAR2
122: , x_msg_count OUT NOCOPY NUMBER
123: , x_msg_data OUT NOCOPY VARCHAR2
124: ) IS

Line 128: , BSC_KPIS_B B

124: ) IS
125: CURSOR c_Filters_Tab IS
126: SELECT DISTINCT C.Source_Code
127: FROM BSC_TAB_INDICATORS A
128: , BSC_KPIS_B B
129: , BSC_SYS_FILTERS_VIEWS C
130: WHERE A.Indicator = B.Indicator
131: AND C.Source_Type = BSC_DIM_FILTERS_PUB.Source_Type_Tab
132: AND C.Source_Code = A.Tab_Id

Line 406: ( p_Kpi_Id IN BSC_KPIS_B.Indicator%TYPE

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
407: , p_Dim_Level_Id IN BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE
408: ) RETURN VARCHAR2
409: IS
410: CURSOR c_Filter_View_Name IS