DBA Data[Home] [Help]

APPS.BISVIEWER_PMF dependencies on BISBV_PERFORMANCE_MEASURES

Line 189: , BISBV_PERFORMANCE_MEASURES M

185: begin
186: SELECT TARGET_LEVEL_ID,MEASURE_SHORT_NAME,MEASURE_NAME
187: INTO l_target_level,MEASURE_SHORT_NAME,MEASURE_NAME
188: FROM BISBV_TARGET_LEVELS L
189: , BISBV_PERFORMANCE_MEASURES M
190: WHERE M.MEASURE_ID = L.MEASURE_ID
191: AND M.MEASURE_SHORT_NAME = p_MEASURE_SHORT_NAME
192: --AND ((l_ORG_LEVEL_ID IS NOT NULL
193: --AND L.ORG_LEVEL_ID = l_ORG_LEVEL_ID)

Line 769: , BISBV_PERFORMANCE_MEASURES M

765:
766: SELECT distinct TARGET_LEVEL_ID, L.MEASURE_ID
767: INTO l_target_level_id, v_meas_id
768: FROM BISBV_TARGET_LEVELS L
769: , BISBV_PERFORMANCE_MEASURES M
770: WHERE M.MEASURE_ID = L.MEASURE_ID
771: AND M.MEASURE_SHORT_NAME = p_MEASURE_SHORT_NAME
772: AND L.ORG_LEVEL_ID = l_ORG_LEVEL_ID
773: AND L.TIME_LEVEL_ID = l_TIME_LEVEL_ID