DBA Data[Home] [Help]

APPS.HR_BIS_ALERTS dependencies on BISBV_TARGET_LEVELS

Line 67: ,unit_of_measure bisbv_target_levels.unit_of_measure%TYPE

63: ,dim4_level_short_name bisfv_target_levels.dimension4_level_short_name%TYPE
64: ,dim4_level_value_id bisbv_targets.dim4_level_value_id%TYPE
65: ,dim5_level_short_name bisfv_target_levels.dimension5_level_short_name%TYPE
66: ,dim5_level_value_id bisbv_targets.dim5_level_value_id%TYPE
67: ,unit_of_measure bisbv_target_levels.unit_of_measure%TYPE
68: ,workflow_item_type bisfv_target_levels.workflow_item_type%TYPE
69: ,workflow_process_short_name bisfv_target_levels.workflow_process_short_name%TYPE
70: ,target bisfv_targets.target%TYPE
71: ,range1_low bisfv_targets.range1_low%TYPE

Line 320: , bisbv_target_levels tl

316: CURSOR pm_cur (p_target_level_id IN NUMBER) IS
317: SELECT pm.measure_id
318: , pm.measure_short_name
319: FROM bisbv_performance_measures pm
320: , bisbv_target_levels tl
321: WHERE pm.measure_id = tl.measure_id
322: AND tl.target_level_id = p_target_level_id;
323: --
324: -- get the target level