eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_OBJECTIVES_LIBRARY

Line 66: objective_id per_objectives_library.objective_id%TYPE,

62: g_curr_sc_pop_tbl g_curr_sc_pop_t;
63:
64: -- Used for populating qualifying objectives
65: TYPE g_qual_obj_r IS RECORD (
66: objective_id per_objectives_library.objective_id%TYPE,
67: objective_name per_objectives_library.objective_name%TYPE,
68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,

Line 67: objective_name per_objectives_library.objective_name%TYPE,

63:
64: -- Used for populating qualifying objectives
65: TYPE g_qual_obj_r IS RECORD (
66: objective_id per_objectives_library.objective_id%TYPE,
67: objective_name per_objectives_library.objective_name%TYPE,
68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,

Line 68: valid_from per_objectives_library.valid_from%TYPE,

64: -- Used for populating qualifying objectives
65: TYPE g_qual_obj_r IS RECORD (
66: objective_id per_objectives_library.objective_id%TYPE,
67: objective_name per_objectives_library.objective_name%TYPE,
68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,

Line 69: valid_to per_objectives_library.valid_to%TYPE,

65: TYPE g_qual_obj_r IS RECORD (
66: objective_id per_objectives_library.objective_id%TYPE,
67: objective_name per_objectives_library.objective_name%TYPE,
68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,

Line 70: target_date per_objectives_library.target_date%TYPE,

66: objective_id per_objectives_library.objective_id%TYPE,
67: objective_name per_objectives_library.objective_name%TYPE,
68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,

Line 71: next_review_date per_objectives_library.next_review_date%TYPE,

67: objective_name per_objectives_library.objective_name%TYPE,
68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,

Line 72: group_code per_objectives_library.group_code%TYPE,

68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,

Line 73: priority_code per_objectives_library.priority_code%TYPE,

69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,

Line 74: appraise_flag per_objectives_library.appraise_flag%TYPE,

70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,

Line 75: weighting_percent per_objectives_library.weighting_percent%TYPE,

71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,

Line 76: target_value per_objectives_library.target_value%TYPE,

72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,

Line 77: uom_code per_objectives_library.uom_code%TYPE,

73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,

Line 78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,

74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,

Line 79: measure_name per_objectives_library.measure_name%TYPE,

75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,
83: success_criteria per_objectives_library.success_criteria%TYPE,

Line 80: measure_type_code per_objectives_library.measure_type_code%TYPE,

76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,
83: success_criteria per_objectives_library.success_criteria%TYPE,
84: comments per_objectives_library.comments%TYPE,

Line 81: measure_comments per_objectives_library.measure_comments%TYPE,

77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,
83: success_criteria per_objectives_library.success_criteria%TYPE,
84: comments per_objectives_library.comments%TYPE,
85: elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE

Line 82: details per_objectives_library.details%TYPE,

78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,
83: success_criteria per_objectives_library.success_criteria%TYPE,
84: comments per_objectives_library.comments%TYPE,
85: elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE
86: );

Line 83: success_criteria per_objectives_library.success_criteria%TYPE,

79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,
83: success_criteria per_objectives_library.success_criteria%TYPE,
84: comments per_objectives_library.comments%TYPE,
85: elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE
86: );
87:

Line 84: comments per_objectives_library.comments%TYPE,

80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,
83: success_criteria per_objectives_library.success_criteria%TYPE,
84: comments per_objectives_library.comments%TYPE,
85: elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE
86: );
87:
88: TYPE g_qual_obj_t IS TABLE OF g_qual_obj_r

Line 1345: FROM per_objectives_library pol, ben_elig_obj_f elig

1341: IS
1342: SELECT objective_id, objective_name, valid_from, valid_to, target_date, next_review_date, group_code, priority_code,
1343: appraise_flag, weighting_percent, target_value, uom_code, measurement_style_code, measure_name,
1344: measure_type_code, measure_comments, details, success_criteria, comments, elig.elig_obj_id
1345: FROM per_objectives_library pol, ben_elig_obj_f elig
1346: WHERE ( pol.valid_from BETWEEN p_start_date AND p_end_date
1347: OR p_start_date BETWEEN pol.valid_from AND NVL (pol.valid_to, TO_DATE ('31-12-4712', 'DD-MM-YYYY'))
1348: )
1349: AND pol.eligibility_type_code <> 'N_P'

Line 1350: AND elig.table_name = 'PER_OBJECTIVES_LIBRARY'

1346: WHERE ( pol.valid_from BETWEEN p_start_date AND p_end_date
1347: OR p_start_date BETWEEN pol.valid_from AND NVL (pol.valid_to, TO_DATE ('31-12-4712', 'DD-MM-YYYY'))
1348: )
1349: AND pol.eligibility_type_code <> 'N_P'
1350: AND elig.table_name = 'PER_OBJECTIVES_LIBRARY'
1351: AND column_name = 'OBJECTIVE_ID'
1352: AND elig.COLUMN_VALUE = pol.objective_id
1353: -- added 23-Jun-2009 schowdhu
1354: AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date AND elig.effective_end_date;