APPS.HR_BIS_ALERTS dependencies on BISFV_TARGET_LEVELS

Line 49: ,target_level_id bisfv_target_levels.target_level_id%TYPE

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
52: ,plan_id bis_target_values.plan_id%TYPE
53: ,org_level_short_name bisfv_target_levels.org_level_short_name%TYPE

Line 50: ,target_level_short_name bisfv_target_levels.target_level_short_name%TYPE

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

Line 53: ,org_level_short_name bisfv_target_levels.org_level_short_name%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
56: ,time_level_short_name bisfv_target_levels.time_level_short_name%TYPE
57: ,dim1_level_short_name bisfv_target_levels.dimension1_level_short_name%TYPE

Line 56: ,time_level_short_name bisfv_target_levels.time_level_short_name%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
56: ,time_level_short_name bisfv_target_levels.time_level_short_name%TYPE
57: ,dim1_level_short_name bisfv_target_levels.dimension1_level_short_name%TYPE
58: ,dim1_level_value_id bisbv_targets.dim1_level_value_id%TYPE
59: ,dim2_level_short_name bisfv_target_levels.dimension2_level_short_name%TYPE
60: ,dim2_level_value_id bisbv_targets.dim2_level_value_id%TYPE

Line 57: ,dim1_level_short_name bisfv_target_levels.dimension1_level_short_name%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
56: ,time_level_short_name bisfv_target_levels.time_level_short_name%TYPE
57: ,dim1_level_short_name bisfv_target_levels.dimension1_level_short_name%TYPE
58: ,dim1_level_value_id bisbv_targets.dim1_level_value_id%TYPE
59: ,dim2_level_short_name bisfv_target_levels.dimension2_level_short_name%TYPE
60: ,dim2_level_value_id bisbv_targets.dim2_level_value_id%TYPE
61: ,dim3_level_short_name bisfv_target_levels.dimension3_level_short_name%TYPE

Line 59: ,dim2_level_short_name bisfv_target_levels.dimension2_level_short_name%TYPE

55: ,time_level_value_id bisbv_targets.time_level_value_id%TYPE
56: ,time_level_short_name bisfv_target_levels.time_level_short_name%TYPE
57: ,dim1_level_short_name bisfv_target_levels.dimension1_level_short_name%TYPE
58: ,dim1_level_value_id bisbv_targets.dim1_level_value_id%TYPE
59: ,dim2_level_short_name bisfv_target_levels.dimension2_level_short_name%TYPE
60: ,dim2_level_value_id bisbv_targets.dim2_level_value_id%TYPE
61: ,dim3_level_short_name bisfv_target_levels.dimension3_level_short_name%TYPE
62: ,dim3_level_value_id bisbv_targets.dim3_level_value_id%TYPE
63: ,dim4_level_short_name bisfv_target_levels.dimension4_level_short_name%TYPE

Line 61: ,dim3_level_short_name bisfv_target_levels.dimension3_level_short_name%TYPE

57: ,dim1_level_short_name bisfv_target_levels.dimension1_level_short_name%TYPE
58: ,dim1_level_value_id bisbv_targets.dim1_level_value_id%TYPE
59: ,dim2_level_short_name bisfv_target_levels.dimension2_level_short_name%TYPE
60: ,dim2_level_value_id bisbv_targets.dim2_level_value_id%TYPE
61: ,dim3_level_short_name bisfv_target_levels.dimension3_level_short_name%TYPE
62: ,dim3_level_value_id bisbv_targets.dim3_level_value_id%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

Line 63: ,dim4_level_short_name bisfv_target_levels.dimension4_level_short_name%TYPE

59: ,dim2_level_short_name bisfv_target_levels.dimension2_level_short_name%TYPE
60: ,dim2_level_value_id bisbv_targets.dim2_level_value_id%TYPE
61: ,dim3_level_short_name bisfv_target_levels.dimension3_level_short_name%TYPE
62: ,dim3_level_value_id bisbv_targets.dim3_level_value_id%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

Line 65: ,dim5_level_short_name bisfv_target_levels.dimension5_level_short_name%TYPE

61: ,dim3_level_short_name bisfv_target_levels.dimension3_level_short_name%TYPE
62: ,dim3_level_value_id bisbv_targets.dim3_level_value_id%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

Line 68: ,workflow_item_type bisfv_target_levels.workflow_item_type%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
72: ,range1_high bisfv_targets.range1_high%TYPE

Line 69: ,workflow_process_short_name bisfv_target_levels.workflow_process_short_name%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
72: ,range1_high bisfv_targets.range1_high%TYPE
73: ,range2_low bisfv_targets.range2_low%TYPE

Line 309: l_bis_tarlev_rec bisfv_target_levels%rowtype;

305: RETURN hri_target_rec_type
306: IS
307:
308: --records from the cursors to be deleted
309: l_bis_tarlev_rec bisfv_target_levels%rowtype;
310: l_bis_target_rec bisfv_targets%rowtype;
311: l_target_rec hri_target_rec_type;
312:
313: --

Line 328: FROM bisfv_target_levels

324: -- get the target level
325: --
326: CURSOR tl_cur (p_target_level_id IN NUMBER) IS
327: SELECT *
328: FROM bisfv_target_levels
329: WHERE target_level_id = p_target_level_id;
330: --
331: -- get the target value
332: --