APPS.HR_COMPLETE_APPRAISAL_SS dependencies on PER_RATING_LEVELS

Line 563: per_rating_levels rating

559: FROM per_competence_elements pce,
560: per_appraisals pa,
561: per_all_people_f ppf,
562: per_competences pc,
563: per_rating_levels rating
564: WHERE pce.TYPE = 'ASSESSMENT'
565: AND pce.object_name = 'APPRAISAL_ID'
566: AND pce.object_id = appr_id
567: AND pa.appraisal_id = pce.object_id

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'

Line 1981: step_value per_rating_levels.step_value%TYPE,

1977: object_version_number per_appraisals.object_version_number%TYPE,
1978: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1979: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1980: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,
1981: step_value per_rating_levels.step_value%TYPE,
1982: overall_perf_rating VARCHAR2 (100)
1983: );
1984:
1985: appraisal_rec appraisal_record;