DBA Data[Home] [Help]

APPS.BIS_PMF_UTILITIES_PUB dependencies on BIS_INDICATORS

Line 117: , BIS_INDICATORS I

113: SELECT TARGET_LEVEL_ID
114: INTO l_target_level
115: FROM
116: BIS_TARGET_LEVELS L
117: , BIS_INDICATORS I
118: WHERE I.INDICATOR_ID = L.INDICATOR_ID
119: AND I.SHORT_NAME = p_MEASURE_SHORT_NAME
120: AND L.ORG_LEVEL_ID = p_ORG_LEVEL
121: AND L.TIME_LEVEL_ID = p_TIME_LEVEL

Line 222: , BIS_INDICATORS I

218: SELECT TARGET_LEVEL_ID
219: INTO l_target_level
220: FROM
221: BIS_TARGET_LEVELS L
222: , BIS_INDICATORS I
223: WHERE I.INDICATOR_ID = L.INDICATOR_ID
224: AND I.SHORT_NAME = p_MEASURE_SHORT_NAME
225: AND L.ORG_LEVEL_ID = l_ORG_LEVEL_ID
226: AND L.TIME_LEVEL_ID = l_TIME_LEVEL_ID