APPS.HR_COMPLETE_APPRAISAL_SS dependencies on PER_RATING_LEVELS

Line 450: per_rating_levels rating

446: select pce.competence_id, pc.name, pce.competence_element_id, pce.proficiency_level_id,
447: pce.business_group_id, pce.enterprise_id,pce.effective_date_from, pce.effective_date_to, pa.appraisal_id, pa.appraisee_person_id,
448: ppf.party_id, decode(rating.step_value, null, null, rating.step_value||' - '||rating.name) prof_level
449: from per_competence_elements pce, per_appraisals pa, per_all_people_f ppf, per_competences pc,
450: per_rating_levels rating
451: where pce.type='ASSESSMENT'
452: and pce.object_name = 'APPRAISAL_ID'
453: and pce.object_id = appr_id
454: and pa.appraisal_id = pce.object_id

Line 1429: from per_appraisals appr, per_rating_levels prl

1425: cursor get_appr_overall_perf(appr_id per_appraisals.appraisal_id%TYPE) IS
1426: select appr.appraisal_id, appr.object_version_number, appr.appraiser_person_id,
1427: appr.appraisee_person_id, appr.overall_performance_level_id, prl.step_value,
1428: (prl.step_value||' - '||prl.name) overall_rating
1429: from per_appraisals appr, per_rating_levels prl
1430: where appraisal_id = appr_id
1431: and appr.overall_performance_level_id = prl.rating_level_id;
1432:
1433: TYPE appraisal_record is RECORD (

Line 1439: step_value per_rating_levels.step_value%TYPE,

1435: object_version_number per_appraisals.object_version_number%TYPE,
1436: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1437: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1438: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,
1439: step_value per_rating_levels.step_value%TYPE,
1440: overall_perf_rating varchar2(100)
1441: );
1442:
1443: appraisal_rec appraisal_record;