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.PA_SEARCH_GLOB dependencies on PER_RATING_LEVELS

Line 31: per_rating_levels prl,

27: --do mandatory and optional match
28: SELECT nvl(sum(decode(pce.mandatory,'Y',1,0)),0), nvl(sum(decode(pce.mandatory,'N',1,0)),0) INTO x_mandatory_match, x_optional_match
29: FROM per_competence_elements pce,
30: per_competence_elements pce2,
31: per_rating_levels prl,
32: per_rating_levels prl2
33: WHERE pce.object_id = p_requirement_id
34: AND pce.object_name = 'OPEN_ASSIGNMENT'
35: AND pce.proficiency_level_id = prl.rating_level_id(+)

Line 32: per_rating_levels prl2

28: SELECT nvl(sum(decode(pce.mandatory,'Y',1,0)),0), nvl(sum(decode(pce.mandatory,'N',1,0)),0) INTO x_mandatory_match, x_optional_match
29: FROM per_competence_elements pce,
30: per_competence_elements pce2,
31: per_rating_levels prl,
32: per_rating_levels prl2
33: WHERE pce.object_id = p_requirement_id
34: AND pce.object_name = 'OPEN_ASSIGNMENT'
35: AND pce.proficiency_level_id = prl.rating_level_id(+)
36: AND pce.competence_id = pce2.competence_id