DBA Data[Home] [Help]

APPS.BSC_UTILITY dependencies on BSC_KPI_DIM_GROUPS

Line 2220: , BSC_KPI_DIM_GROUPS G

2216: BEGIN
2217: SELECT COUNT(1) INTO l_Count
2218: FROM BSC_SYS_DIM_GROUPS_VL B
2219: , BSC_KPIS_B K
2220: , BSC_KPI_DIM_GROUPS G
2221: WHERE B.SHORT_NAME = p_Short_Name
2222: AND K.SHORT_NAME = B.SHORT_NAME
2223: AND G.INDICATOR = K.INDICATOR;
2224:

Line 2240: BSC_KPI_DIM_GROUPS k

2236: BEGIN
2237: SELECT COUNT(1)
2238: INTO l_Count
2239: FROM BSC_SYS_DIM_GROUPS_VL d,
2240: BSC_KPI_DIM_GROUPS k
2241: WHERE d.DIM_GROUP_ID = k.DIM_GROUP_ID
2242: AND BSC_BIS_DIMENSION_PUB.Get_Dimension_Source(d.SHORT_NAME)=BSC_UTILITY.c_PMF
2243: AND d.SHORT_NAME=p_Short_Name;
2244: