APPS.HR_BIS_ALERTS dependencies on BISBV_PERFORMANCE_MEASURES

Line 47: (measure_short_name bisbv_performance_measures.measure_short_name%TYPE

43: g_session_rec hri_session_rec_type;
44:
45: --Record to store the required Information pertaining to a target
46: TYPE hri_target_rec_type IS RECORD
47: (measure_short_name bisbv_performance_measures.measure_short_name%TYPE
48: ,target_id bis_target_values.target_id%TYPE
49: ,target_level_id bisfv_target_levels.target_level_id%TYPE
50: ,target_level_short_name bisfv_target_levels.target_level_short_name%TYPE
51: ,measure_id bisbv_performance_measures.measure_id%TYPE

Line 51: ,measure_id bisbv_performance_measures.measure_id%TYPE

47: (measure_short_name bisbv_performance_measures.measure_short_name%TYPE
48: ,target_id bis_target_values.target_id%TYPE
49: ,target_level_id bisfv_target_levels.target_level_id%TYPE
50: ,target_level_short_name bisfv_target_levels.target_level_short_name%TYPE
51: ,measure_id bisbv_performance_measures.measure_id%TYPE
52: ,plan_id bis_target_values.plan_id%TYPE
53: ,org_level_short_name bisfv_target_levels.org_level_short_name%TYPE
54: ,org_level_value_id bisbv_targets.org_level_value_id%TYPE
55: ,time_level_value_id bisbv_targets.time_level_value_id%TYPE

Line 319: FROM bisbv_performance_measures pm

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