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 57: objective_id per_objectives_library.objective_id%TYPE,

53: g_curr_sc_pop_tbl g_curr_sc_pop_t;
54:
55: -- Used for populating qualifying objectives
56: TYPE g_qual_obj_r IS RECORD (
57: objective_id per_objectives_library.objective_id%TYPE,
58: objective_name per_objectives_library.objective_name%TYPE,
59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,

Line 58: objective_name per_objectives_library.objective_name%TYPE,

54:
55: -- Used for populating qualifying objectives
56: TYPE g_qual_obj_r IS RECORD (
57: objective_id per_objectives_library.objective_id%TYPE,
58: objective_name per_objectives_library.objective_name%TYPE,
59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,

Line 59: valid_from per_objectives_library.valid_from%TYPE,

55: -- Used for populating qualifying objectives
56: TYPE g_qual_obj_r IS RECORD (
57: objective_id per_objectives_library.objective_id%TYPE,
58: objective_name per_objectives_library.objective_name%TYPE,
59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,

Line 60: valid_to per_objectives_library.valid_to%TYPE,

56: TYPE g_qual_obj_r IS RECORD (
57: objective_id per_objectives_library.objective_id%TYPE,
58: objective_name per_objectives_library.objective_name%TYPE,
59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,

Line 61: target_date per_objectives_library.target_date%TYPE,

57: objective_id per_objectives_library.objective_id%TYPE,
58: objective_name per_objectives_library.objective_name%TYPE,
59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,

Line 62: next_review_date per_objectives_library.NEXT_review_date%TYPE,

58: objective_name per_objectives_library.objective_name%TYPE,
59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,

Line 63: group_code per_objectives_library.group_code%TYPE,

59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,

Line 64: priority_code per_objectives_library.priority_code%TYPE,

60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,

Line 65: appraise_flag per_objectives_library.appraise_flag%TYPE,

61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,

Line 66: weighting_percent per_objectives_library.weighting_percent%TYPE,

62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,

Line 67: target_value per_objectives_library.target_value%TYPE,

63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,

Line 68: uom_code per_objectives_library.uom_code%TYPE,

64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,

Line 69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,

65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,

Line 70: measure_name per_objectives_library.measure_name%TYPE,

66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,
74: success_criteria per_objectives_library.success_criteria%TYPE,

Line 71: measure_type_code per_objectives_library.measure_type_code%TYPE,

67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,
74: success_criteria per_objectives_library.success_criteria%TYPE,
75: comments per_objectives_library.comments%TYPE,

Line 72: measure_comments per_objectives_library.measure_comments%TYPE,

68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,
74: success_criteria per_objectives_library.success_criteria%TYPE,
75: comments per_objectives_library.comments%TYPE,
76: elig_obj_id ben_elig_obj_f.ELIG_OBJ_ID%type);

Line 73: details per_objectives_library.details%TYPE,

69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,
74: success_criteria per_objectives_library.success_criteria%TYPE,
75: comments per_objectives_library.comments%TYPE,
76: elig_obj_id ben_elig_obj_f.ELIG_OBJ_ID%type);
77:

Line 74: success_criteria per_objectives_library.success_criteria%TYPE,

70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,
74: success_criteria per_objectives_library.success_criteria%TYPE,
75: comments per_objectives_library.comments%TYPE,
76: elig_obj_id ben_elig_obj_f.ELIG_OBJ_ID%type);
77:
78: TYPE g_qual_obj_t is table of g_qual_obj_r INDEX BY binary_integer;

Line 75: comments per_objectives_library.comments%TYPE,

71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,
74: success_criteria per_objectives_library.success_criteria%TYPE,
75: comments per_objectives_library.comments%TYPE,
76: elig_obj_id ben_elig_obj_f.ELIG_OBJ_ID%type);
77:
78: TYPE g_qual_obj_t is table of g_qual_obj_r INDEX BY binary_integer;
79: g_qual_obj_tbl g_qual_obj_t;

Line 907: from per_objectives_library pol,

903: select objective_id, objective_name, valid_from, valid_to, target_date, next_review_date, group_code,
904: priority_code, appraise_flag, weighting_percent, target_value, uom_code, measurement_style_code,
905: measure_name, measure_type_code, measure_comments, details, success_criteria, comments,
906: elig.elig_obj_id
907: from per_objectives_library pol,
908: ben_elig_obj_f elig
909: where (pol.valid_from between p_start_date and p_end_date OR
910: p_start_date between pol.valid_from and nvl(pol.valid_to,to_date('31-12-4712', 'DD-MM-YYYY')))
911: and POL.ELIGIBILITY_TYPE_CODE <> 'N_P'

Line 912: and elig.table_name = 'PER_OBJECTIVES_LIBRARY'

908: ben_elig_obj_f elig
909: where (pol.valid_from between p_start_date and p_end_date OR
910: p_start_date between pol.valid_from and nvl(pol.valid_to,to_date('31-12-4712', 'DD-MM-YYYY')))
911: and POL.ELIGIBILITY_TYPE_CODE <> 'N_P'
912: and elig.table_name = 'PER_OBJECTIVES_LIBRARY'
913: and column_name = 'OBJECTIVE_ID'
914: and elig.column_value = pol.objective_id;
915:
916: Begin