APPS.HR_COMPLETE_APPRAISAL_SS dependencies on HR_LOOKUPS

Line 188: appraisal_status hr_lookups.meaning%TYPE,

184:
185: PROCEDURE generate_appraisal_status
186: (appraisal_date per_appraisals.appraisal_date%TYPE,
187: appraisee_name per_all_people_f.full_name%TYPE,
188: appraisal_status hr_lookups.meaning%TYPE,
189: appraisal_type hr_lookups.meaning%TYPE,
190: result fnd_new_messages.message_text%TYPE,
191: reason varchar2,
192: p_log in out nocopy varchar2

Line 189: appraisal_type hr_lookups.meaning%TYPE,

185: PROCEDURE generate_appraisal_status
186: (appraisal_date per_appraisals.appraisal_date%TYPE,
187: appraisee_name per_all_people_f.full_name%TYPE,
188: appraisal_status hr_lookups.meaning%TYPE,
189: appraisal_type hr_lookups.meaning%TYPE,
190: result fnd_new_messages.message_text%TYPE,
191: reason varchar2,
192: p_log in out nocopy varchar2
193: )

Line 265: from per_appraisals appr, per_all_people_f ppf, hr_lookups apprstatus,

261: select appr.appraisal_id, appr.object_version_number,
262: appr.appraiser_person_id, appr.appraisee_person_id, ppf.full_name,
263: appr.appraisal_date, apprstatus.meaning appraisal_status, apprtype.meaning appraisal_type,
264: nvl(appr.provide_overall_feedback,'N') provide_overall_feedback, appr.appraisal_system_status
265: from per_appraisals appr, per_all_people_f ppf, hr_lookups apprstatus,
266: hr_lookups apprtype
267: where appr.appraisal_id = appr_id
268: and ppf.person_id = appr.appraisee_person_id
269: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date

Line 266: hr_lookups apprtype

262: appr.appraiser_person_id, appr.appraisee_person_id, ppf.full_name,
263: appr.appraisal_date, apprstatus.meaning appraisal_status, apprtype.meaning appraisal_type,
264: nvl(appr.provide_overall_feedback,'N') provide_overall_feedback, appr.appraisal_system_status
265: from per_appraisals appr, per_all_people_f ppf, hr_lookups apprstatus,
266: hr_lookups apprtype
267: where appr.appraisal_id = appr_id
268: and ppf.person_id = appr.appraisee_person_id
269: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
270: and apprstatus.lookup_type = 'APPRAISAL_SYSTEM_STATUS'

Line 277: from per_appraisals appr, hr_lookups hrl

273: and apprtype.lookup_code = appr.system_type;
274:
275: cursor get_appraisal_status(appr_id per_appraisals.appraisal_id%TYPE) IS
276: select hrl.meaning
277: from per_appraisals appr, hr_lookups hrl
278: where appraisal_id = appr_id
279: and hrl.lookup_type = 'APPRAISAL_SYSTEM_STATUS'
280: and appr.appraisal_system_status = hrl.lookup_code;
281:

Line 290: apprstatus hr_lookups.meaning%TYPE,

286: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
287: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
288: full_name per_all_people_f.full_name%TYPE,
289: appraisal_date per_appraisals.appraisal_date%TYPE,
290: apprstatus hr_lookups.meaning%TYPE,
291: apprtype hr_lookups.meaning%TYPE,
292: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,
293: appraisal_system_status per_appraisals.appraisal_system_status%TYPE
294: );

Line 291: apprtype hr_lookups.meaning%TYPE,

287: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
288: full_name per_all_people_f.full_name%TYPE,
289: appraisal_date per_appraisals.appraisal_date%TYPE,
290: apprstatus hr_lookups.meaning%TYPE,
291: apprtype hr_lookups.meaning%TYPE,
292: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,
293: appraisal_system_status per_appraisals.appraisal_system_status%TYPE
294: );
295:

Line 298: lv_appr_result_status hr_lookups.meaning%TYPE;

294: );
295:
296: appraisal_record appraisal_rec;
297: error_message varchar2(500) default null;
298: lv_appr_result_status hr_lookups.meaning%TYPE;
299:
300: BEGIN
301:
302: hr_multi_message.enable_message_list;

Line 978: ' ota_activity_versions tav, hr_lookups hrl ' ||

974:
975: query_lp_courses VARCHAR2(4000) := ' select tav.version_name course_name, hrl.meaning member_status, ' ||
976: ' lpme.completion_target_date, lpme.completion_date ' ||
977: ' from ota_learning_path_members lpm, ota_lp_member_enrollments lpme, ' ||
978: ' ota_activity_versions tav, hr_lookups hrl ' ||
979: ' where lpm.learning_path_id = :1 ' ||
980: ' and lpme.learning_path_member_id = lpm.learning_path_member_id ' ||
981: ' and hrl.lookup_code = lpme.member_status_code ' ||
982: ' and hrl.lookup_type = ''OTA_LP_MEMBER_STATUS''' ||

Line 987: lv_course_status hr_lookups.meaning%TYPE;

983: ' and tav.activity_version_id = lpm.activity_version_id ';
984:
985: l_lp_courses cur_typ;
986: lv_course_name varchar2(80);
987: lv_course_status hr_lookups.meaning%TYPE;
988: lv_course_targe_date date;
989: lv_course_compl_date date;
990: ln_count number default 0;
991: BEGIN

Line 1079: ' hr_lookups hrl ' ||

1075:
1076: query_str VARCHAR2(4000) := ' select lp.learning_path_id, lp.display_to_learner_flag, lp.object_version_number, ' ||
1077: ' lpe.lp_enrollment_id,lpe.object_version_number,hrl.meaning , lptl.name ' ||
1078: ' from ota_learning_paths lp, ota_learning_paths_tl lptl, ota_lp_enrollments lpe, ' ||
1079: ' hr_lookups hrl ' ||
1080: ' where lp.source_id = :1 and lp.path_source_code= :2 ' ||
1081: ' and lp.source_function_code = :3 ' ||
1082: ' and lptl.learning_path_id = lp.learning_path_id ' ||
1083: ' and lptl.language = userenv(''lang'') ' ||

Line 1091: ' ota_lp_enrollments lpe, hr_lookups hrl ' ||

1087:
1088: query_lp_status VARCHAR2(4000) :=
1089: ' select hrl.meaning path_status_code ' ||
1090: ' from ota_learning_paths lp, ' ||
1091: ' ota_lp_enrollments lpe, hr_lookups hrl ' ||
1092: ' where lp.learning_path_id = :1 ' ||
1093: ' and lpe.learning_path_id = lp.learning_path_id ' ||
1094: ' and lpe.path_status_code = hrl.lookup_code ' ||
1095: ' and hrl.lookup_type = ''OTA_LEARNING_PATH_STATUS''';