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_HR_COMPETENCE_UTILS dependencies on PER_RATING_LEVELS

Line 18: ,p_rating_level_id IN per_rating_levels.rating_level_id%TYPE

14: --
15:
16: procedure Check_Rating_Level_Or_Id
17: ( p_competence_id IN per_competences.competence_id%TYPE
18: ,p_rating_level_id IN per_rating_levels.rating_level_id%TYPE
19: ,p_rating_level IN per_rating_levels.step_value%TYPE
20: ,p_check_id_flag IN VARCHAR2
21: ,x_rating_level_id OUT NOCOPY per_rating_levels.rating_level_id%TYPE --File.Sql.39 bug 4440895
22: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 19: ,p_rating_level IN per_rating_levels.step_value%TYPE

15:
16: procedure Check_Rating_Level_Or_Id
17: ( p_competence_id IN per_competences.competence_id%TYPE
18: ,p_rating_level_id IN per_rating_levels.rating_level_id%TYPE
19: ,p_rating_level IN per_rating_levels.step_value%TYPE
20: ,p_check_id_flag IN VARCHAR2
21: ,x_rating_level_id OUT NOCOPY per_rating_levels.rating_level_id%TYPE --File.Sql.39 bug 4440895
22: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23: ,x_error_msg_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 21: ,x_rating_level_id OUT NOCOPY per_rating_levels.rating_level_id%TYPE --File.Sql.39 bug 4440895

17: ( p_competence_id IN per_competences.competence_id%TYPE
18: ,p_rating_level_id IN per_rating_levels.rating_level_id%TYPE
19: ,p_rating_level IN per_rating_levels.step_value%TYPE
20: ,p_check_id_flag IN VARCHAR2
21: ,x_rating_level_id OUT NOCOPY per_rating_levels.rating_level_id%TYPE --File.Sql.39 bug 4440895
22: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23: ,x_error_msg_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
24:
25: l_current_id NUMBER := NULL;

Line 477: PER_RATING_LEVELS rl

473: l_competence_alias,
474: l_competence_level
475: FROM PER_COMPETENCE_ELEMENTS comp_ele,
476: PER_COMPETENCES comp,
477: PER_RATING_LEVELS rl
478: WHERE comp_ele.competence_id = comp.competence_id
479: AND comp_ele.person_id = p_person_id
480: AND comp_ele.proficiency_level_id = rl.rating_level_id (+);
481: