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_COMPLETE_APPRAISAL_SS dependencies on PER_COMPETENCES

Line 449: from per_competence_elements pce, per_appraisals pa, per_all_people_f ppf, per_competences pc,

445: cursor get_assessment_competences (appr_id IN number) is
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