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

Line 14: from per_competence_elements pce, per_rating_levels prl

10: ) RETURN varchar2 is
11:
12: Cursor CompRecordWithLevel is
13: Select nvl(pce.proficiency_level_id, -100)
14: from per_competence_elements pce, per_rating_levels prl
15: where pce.competence_id = p_comp_id
16: and pce.person_id = p_person_id
17: and prl.rating_level_id(+) = pce.proficiency_level_id
18: and prl.step_value >= (select step_value from per_rating_levels where rating_level_id = p_level_id)

Line 18: and prl.step_value >= (select step_value from per_rating_levels where rating_level_id = p_level_id)

14: from per_competence_elements pce, per_rating_levels prl
15: where pce.competence_id = p_comp_id
16: and pce.person_id = p_person_id
17: and prl.rating_level_id(+) = pce.proficiency_level_id
18: and prl.step_value >= (select step_value from per_rating_levels where rating_level_id = p_level_id)
19: and (trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate)) and nvl(pce.effective_date_to, trunc(sysdate)));
20:
21: Cursor CompRecordWithNullLevel is
22: Select nvl(pce.proficiency_level_id, -100)

Line 88: PER_RATING_LEVELS PRL,

84: SELECT
85: Decode(PRL.STEP_VALUE, null, -1, PRL.STEP_VALUE),
86: PCE.COMPETENCE_ELEMENT_ID
87: FROM
88: PER_RATING_LEVELS PRL,
89: PER_COMPETENCE_ELEMENTS PCE
90: WHERE
91: PCE.PROFICIENCY_LEVEL_ID = PRL.RATING_LEVEL_ID (+)
92: and (trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate)) and nvl(pce.effective_date_to, trunc(sysdate)))

Line 102: PER_RATING_LEVELS PRL

98: Cursor GetPrereqCompStepValue is
99: SELECT
100: PRL.STEP_VALUE
101: FROM
102: PER_RATING_LEVELS PRL
103: WHERE
104: PRL.RATING_LEVEL_ID = p_level_id;
105:
106: Cursor GetCompHighesteStepValue IS

Line 114: per_rating_levels prl

110: WHERE COMPETENCE_ID = p_comp_id;
111: */
112: select MAX(step_value)
113: from
114: per_rating_levels prl
115: ,per_competences pce
116: where (prl.rating_scale_id = pce.rating_scale_id
117: OR pce.competence_id = prl.competence_id)
118: AND pce.competence_id = p_comp_id;

Line 128: per_rating_levels prl

124: WHERE COMPETENCE_ID = p_comp_id;
125: */
126: select MIN(step_value)
127: from
128: per_rating_levels prl
129: ,per_competences pce
130: where (prl.rating_scale_id = pce.rating_scale_id
131: OR pce.competence_id = prl.competence_id)
132: AND pce.competence_id = p_comp_id;

Line 136: l_lrn_step_value per_rating_levels.step_value%type;

132: AND pce.competence_id = p_comp_id;
133:
134:
135: l_lrn_comp_el_id per_competence_elements.competence_element_id%type;
136: l_lrn_step_value per_rating_levels.step_value%type;
137:
138: l_prereq_step_value per_rating_levels.step_value%type;
139: l_comp_max_step_value per_rating_levels.step_value%type;
140: l_comp_min_step_value per_rating_levels.step_value%type;

Line 138: l_prereq_step_value per_rating_levels.step_value%type;

134:
135: l_lrn_comp_el_id per_competence_elements.competence_element_id%type;
136: l_lrn_step_value per_rating_levels.step_value%type;
137:
138: l_prereq_step_value per_rating_levels.step_value%type;
139: l_comp_max_step_value per_rating_levels.step_value%type;
140: l_comp_min_step_value per_rating_levels.step_value%type;
141: l_return_status varchar2(1);
142:

Line 139: l_comp_max_step_value per_rating_levels.step_value%type;

135: l_lrn_comp_el_id per_competence_elements.competence_element_id%type;
136: l_lrn_step_value per_rating_levels.step_value%type;
137:
138: l_prereq_step_value per_rating_levels.step_value%type;
139: l_comp_max_step_value per_rating_levels.step_value%type;
140: l_comp_min_step_value per_rating_levels.step_value%type;
141: l_return_status varchar2(1);
142:
143: Begin

Line 140: l_comp_min_step_value per_rating_levels.step_value%type;

136: l_lrn_step_value per_rating_levels.step_value%type;
137:
138: l_prereq_step_value per_rating_levels.step_value%type;
139: l_comp_max_step_value per_rating_levels.step_value%type;
140: l_comp_min_step_value per_rating_levels.step_value%type;
141: l_return_status varchar2(1);
142:
143: Begin
144: l_return_status := 'S'; -- Prereq comp(PC) can be specified