APPS.PA_HR_COMPETENCE_UTILS dependencies on PER_COMPETENCE_LEVELS_V

Line 31: FROM per_competence_levels_v

27: l_id_found_flag VARCHAR(1) := 'N';
28:
29: CURSOR r_ids IS
30: SELECT rating_level_id
31: FROM per_competence_levels_v
32: WHERE competence_id = p_competence_id
33: AND step_value = p_rating_level;
34: BEGIN
35: pa_debug.init_err_stack ('pa_competence_utils.check_rating_level_or_id');

Line 40: FROM per_competence_levels_v

36: IF (p_rating_level_id is not null) THEN
37: IF (p_check_id_flag = 'Y') THEN
38: SELECT rating_level_id
39: INTO x_rating_level_id
40: FROM per_competence_levels_v
41: WHERE competence_id = p_competence_id
42: AND rating_level_id = p_rating_level_id;
43: ELSIF (p_check_id_flag = 'N') THEN
44: x_rating_level_id := p_rating_level_id;

Line 80: FROM per_competence_levels_v

76: ELSE -- Find ID since it was not passed.
77: IF (p_rating_level IS NOT NULL) THEN
78: SELECT rating_level_id
79: INTO x_rating_level_id
80: FROM per_competence_levels_v
81: WHERE competence_id = p_competence_id
82: AND step_value = p_rating_level;
83: ELSE
84: x_rating_level_id := NULL;