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.

[Home] [Help]

APPS.HR_COMPLETE_APPRAISAL_SS dependencies on HR_LOOKUPS

Line 216: appraisal_status hr_lookups.meaning%TYPE,

212:
213: PROCEDURE generate_appraisal_status (
214: appraisal_date per_appraisals.appraisal_date%TYPE,
215: appraisee_name per_all_people_f.full_name%TYPE,
216: appraisal_status hr_lookups.meaning%TYPE,
217: appraisal_type hr_lookups.meaning%TYPE,
218: RESULT fnd_new_messages.MESSAGE_TEXT%TYPE,
219: reason VARCHAR2,
220: p_log IN OUT NOCOPY VARCHAR2

Line 217: appraisal_type hr_lookups.meaning%TYPE,

213: PROCEDURE generate_appraisal_status (
214: appraisal_date per_appraisals.appraisal_date%TYPE,
215: appraisee_name per_all_people_f.full_name%TYPE,
216: appraisal_status hr_lookups.meaning%TYPE,
217: appraisal_type hr_lookups.meaning%TYPE,
218: RESULT fnd_new_messages.MESSAGE_TEXT%TYPE,
219: reason VARCHAR2,
220: p_log IN OUT NOCOPY VARCHAR2
221: )

Line 327: hr_lookups apprstatus,

323: NVL (appr.provide_overall_feedback, 'N') provide_overall_feedback,
324: appr.appraisal_system_status
325: FROM per_appraisals appr,
326: per_all_people_f ppf,
327: hr_lookups apprstatus,
328: hr_lookups apprtype
329: WHERE appr.appraisal_id = appr_id
330: AND ppf.person_id = appr.appraisee_person_id
331: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 328: hr_lookups apprtype

324: appr.appraisal_system_status
325: FROM per_appraisals appr,
326: per_all_people_f ppf,
327: hr_lookups apprstatus,
328: hr_lookups apprtype
329: WHERE appr.appraisal_id = appr_id
330: AND ppf.person_id = appr.appraisee_person_id
331: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
332: AND apprstatus.lookup_type = 'APPRAISAL_SYSTEM_STATUS'

Line 340: FROM per_appraisals appr, hr_lookups hrl

336:
337: CURSOR get_appraisal_status (appr_id per_appraisals.appraisal_id%TYPE)
338: IS
339: SELECT hrl.meaning
340: FROM per_appraisals appr, hr_lookups hrl
341: WHERE appraisal_id = appr_id
342: AND hrl.lookup_type = 'APPRAISAL_SYSTEM_STATUS'
343: AND appr.appraisal_system_status = hrl.lookup_code;
344:

Line 352: apprstatus hr_lookups.meaning%TYPE,

348: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
349: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
350: full_name per_all_people_f.full_name%TYPE,
351: appraisal_date per_appraisals.appraisal_date%TYPE,
352: apprstatus hr_lookups.meaning%TYPE,
353: apprtype hr_lookups.meaning%TYPE,
354: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,
355: appraisal_system_status per_appraisals.appraisal_system_status%TYPE
356: );

Line 353: apprtype hr_lookups.meaning%TYPE,

349: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
350: full_name per_all_people_f.full_name%TYPE,
351: appraisal_date per_appraisals.appraisal_date%TYPE,
352: apprstatus hr_lookups.meaning%TYPE,
353: apprtype hr_lookups.meaning%TYPE,
354: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,
355: appraisal_system_status per_appraisals.appraisal_system_status%TYPE
356: );
357:

Line 360: lv_appr_result_status hr_lookups.meaning%TYPE;

356: );
357:
358: appraisal_record appraisal_rec;
359: error_message VARCHAR2 (500) DEFAULT NULL;
360: lv_appr_result_status hr_lookups.meaning%TYPE;
361: BEGIN
362: hr_multi_message.enable_message_list;
363:
364: OPEN get_appraisal_info (appr_id);

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

1346: query_lp_courses VARCHAR2 (4000)
1347: := ' select tav.version_name course_name, hrl.meaning member_status, '
1348: || ' lpme.completion_target_date, lpme.completion_date '
1349: || ' from ota_learning_path_members lpm, ota_lp_member_enrollments lpme, '
1350: || ' ota_activity_versions tav, hr_lookups hrl '
1351: || ' where lpm.learning_path_id = :1 '
1352: || ' and lpme.learning_path_member_id = lpm.learning_path_member_id '
1353: || ' and hrl.lookup_code = lpme.member_status_code '
1354: || ' and hrl.lookup_type = ''OTA_LP_MEMBER_STATUS'''

Line 1358: lv_course_status hr_lookups.meaning%TYPE;

1354: || ' and hrl.lookup_type = ''OTA_LP_MEMBER_STATUS'''
1355: || ' and tav.activity_version_id = lpm.activity_version_id ';
1356: l_lp_courses cur_typ;
1357: lv_course_name VARCHAR2 (80);
1358: lv_course_status hr_lookups.meaning%TYPE;
1359: lv_course_targe_date DATE;
1360: lv_course_compl_date DATE;
1361: ln_count NUMBER DEFAULT 0;
1362: BEGIN

Line 1485: || ' hr_lookups hrl '

1481: query_str VARCHAR2 (4000)
1482: := ' select lp.learning_path_id, lp.display_to_learner_flag, lp.object_version_number, '
1483: || ' lpe.lp_enrollment_id,lpe.object_version_number,hrl.meaning , lptl.name '
1484: || ' from ota_learning_paths lp, ota_learning_paths_tl lptl, ota_lp_enrollments lpe, '
1485: || ' hr_lookups hrl '
1486: || ' where lp.source_id = :1 and lp.path_source_code= :2 '
1487: || ' and lp.source_function_code = :3 '
1488: || ' and lptl.learning_path_id = lp.learning_path_id '
1489: || ' and lptl.language = userenv(''lang'') '

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

1492: || ' and hrl.lookup_type = ''OTA_LEARNING_PATH_STATUS''';
1493: query_lp_status VARCHAR2 (4000)
1494: := ' select hrl.meaning path_status_code '
1495: || ' from ota_learning_paths lp, '
1496: || ' ota_lp_enrollments lpe, hr_lookups hrl '
1497: || ' where lp.learning_path_id = :1 '
1498: || ' and lpe.learning_path_id = lp.learning_path_id '
1499: || ' and lpe.path_status_code = hrl.lookup_code '
1500: || ' and hrl.lookup_type = ''OTA_LEARNING_PATH_STATUS''';

Line 1967: FROM per_appraisals appr, per_rating_levels prl, hr_lookups hrl

1963: appr.appraisee_person_id,
1964: appr.overall_performance_level_id,
1965: prl.step_value,
1966: (prl.step_value || ' - ' || prl.NAME) overall_rating
1967: FROM per_appraisals appr, per_rating_levels prl, hr_lookups hrl
1968: WHERE appraisal_id = appr_id
1969: AND appr.overall_performance_level_id = prl.rating_level_id
1970: AND hrl.lookup_code = TO_CHAR (prl.step_value)
1971: AND hrl.lookup_type = 'PERFORMANCE_RATING'