APPS.BISVIEWER_PMF dependencies on BISBV_TARGET_LEVELS

Line 182: -- dmarkman 07/20/2000 do 'select' on BISBV_TARGET_LEVELS instead of BIS_TARGET_LEVELS, BIS_INDICATORS

178: --*/
179: -- Debugging messages end --------------------------------------------------
180:
181:
182: -- dmarkman 07/20/2000 do 'select' on BISBV_TARGET_LEVELS instead of BIS_TARGET_LEVELS, BIS_INDICATORS
183: -- dmarkman 12/01/2001 org and time are not mandatory(could be NULL)
184: --/*
185: begin
186: SELECT TARGET_LEVEL_ID,MEASURE_SHORT_NAME,MEASURE_NAME

Line 188: FROM BISBV_TARGET_LEVELS L

184: --/*
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

Line 768: FROM BISBV_TARGET_LEVELS L

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