DBA Data[Home] [Help]

APPS.BIS_PMF_UTILITIES_PUB dependencies on BIS_TARGET_LEVELS

Line 68: FROM BIS_TARGET_LEVELS L

64: --
65: BEGIN
66: SELECT TARGET_LEVEL_ID
67: INTO l_target_level
68: FROM BIS_TARGET_LEVELS L
69: WHERE L.SHORT_NAME = p_TARGET_LEVEL_SHORT_NAME;
70: --
71: l_target := Get_Target_Value( l_target_level
72: , p_ORG_LEVEL_VALUE

Line 116: BIS_TARGET_LEVELS L

112: BEGIN
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

Line 221: BIS_TARGET_LEVELS L

217: --
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