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

Line 30: from per_rating_levels ratl

26: ,hr_general.decode_lookup ('PROFICIENCY_SOURCE' ,cmpe.source_of_proficiency_level) src_proficiency_lvl_desc
27: ,cmpe.comments
28: ,cvl.competence_alias
29: ,cmpe.status -- added for Competnce Qualification link enahncement
30: from per_rating_levels ratl
31: ,per_competence_elements cmpe
32: ,per_competences_vl cvl
33: where cmpe.competence_element_id = p_competence_element_id
34: and cmpe.competence_id = cvl.competence_id

Line 39: select step_value from per_rating_levels

35: and cmpe.proficiency_level_id = ratl.rating_level_id (+)
36: and trunc(sysdate) between nvl(cmpe.effective_date_from, trunc(sysdate))
37: and nvl(cmpe.effective_date_to, trunc(sysdate));
38: cursor get_curr_step_value(p_proficiency_level_id in number) is
39: select step_value from per_rating_levels
40: where rating_level_id = p_proficiency_level_id;
41: cursor get_previous_step_value(p_competence_element_id in number) is
42: select a.step_value
43: from per_rating_levels a,per_competence_elements b

Line 43: from per_rating_levels a,per_competence_elements b

39: select step_value from per_rating_levels
40: where rating_level_id = p_proficiency_level_id;
41: cursor get_previous_step_value(p_competence_element_id in number) is
42: select a.step_value
43: from per_rating_levels a,per_competence_elements b
44: where b.proficiency_level_id = a.rating_level_id(+)
45: and b.competence_element_id = p_competence_element_id;
46: cursor get_prev_prof_lvl_id(p_competence_element_id in number) is
47: select proficiency_level_id

Line 1016: l_step_value per_rating_levels.step_value%type;

1012: l_system_generated varchar2(1) default null;
1013: l_upgraded_from_rec_id number DEFAULT Null;
1014: l_preupd_proficy_lvl_id number default NULL;
1015: l_competence_name per_competences_vl.name%type;
1016: l_step_value per_rating_levels.step_value%type;
1017: l_item_type hr_api_transaction_steps.item_type%type;
1018: l_item_key hr_api_transaction_steps.item_key%type;
1019: l_activity_id hr_api_transaction_steps.ACTIVITY_ID%type;
1020: l_cmp_element_id per_competence_elements.competence_element_id%type;

Line 2536: from per_competences_vl cvl, per_rating_levels ratl

2532: ,p_error_message => p_error_message);
2533: IF p_step_value IS NOT NULL Then
2534: select ratl.step_value,ratl.rating_level_id
2535: into l_step_value,l_new_prof_level
2536: from per_competences_vl cvl, per_rating_levels ratl
2537: where ((ratl.competence_id = cvl.competence_id and cvl.competence_id = p_competence_id)
2538: or (cvl.rating_scale_id = ratl.rating_scale_id and cvl.competence_id = p_competence_id))
2539: and ratl.step_value = p_step_value;
2540: r_step_value := l_step_value ;

Line 2745: select per_rating_levels.step_value ,per_rating_levels.rating_level_id

2741: hr_utility.set_location(l_proc,35);
2742: If p_step_value is not null then
2743: Begin
2744: hr_utility.set_location(l_proc,40);
2745: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2746: into p_step_value,p_prof_level_id
2747: from per_competences_vl, per_rating_levels
2748: where ((per_rating_levels.competence_id = per_competences_vl.competence_id
2749: or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)

Line 2747: from per_competences_vl, per_rating_levels

2743: Begin
2744: hr_utility.set_location(l_proc,40);
2745: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2746: into p_step_value,p_prof_level_id
2747: from per_competences_vl, per_rating_levels
2748: where ((per_rating_levels.competence_id = per_competences_vl.competence_id
2749: or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2750: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value))
2751: and (per_competences_vl.business_group_id+0 = p_business_group_id

Line 2748: where ((per_rating_levels.competence_id = per_competences_vl.competence_id

2744: hr_utility.set_location(l_proc,40);
2745: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2746: into p_step_value,p_prof_level_id
2747: from per_competences_vl, per_rating_levels
2748: where ((per_rating_levels.competence_id = per_competences_vl.competence_id
2749: or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2750: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value))
2751: and (per_competences_vl.business_group_id+0 = p_business_group_id
2752: or per_competences_vl.business_group_id is null);

Line 2749: or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)

2745: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2746: into p_step_value,p_prof_level_id
2747: from per_competences_vl, per_rating_levels
2748: where ((per_rating_levels.competence_id = per_competences_vl.competence_id
2749: or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2750: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value))
2751: and (per_competences_vl.business_group_id+0 = p_business_group_id
2752: or per_competences_vl.business_group_id is null);
2753: Exception when OTHERS then

Line 2750: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value))

2746: into p_step_value,p_prof_level_id
2747: from per_competences_vl, per_rating_levels
2748: where ((per_rating_levels.competence_id = per_competences_vl.competence_id
2749: or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2750: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value))
2751: and (per_competences_vl.business_group_id+0 = p_business_group_id
2752: or per_competences_vl.business_group_id is null);
2753: Exception when OTHERS then
2754: hr_utility.set_location(l_proc,560);

Line 2857: select per_rating_levels.step_value ,per_rating_levels.rating_level_id

2853: begin
2854: hr_utility.set_location(' Entering:' || l_proc,5);
2855: if p_step_value is not null then
2856: hr_utility.set_location(l_proc,10);
2857: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2858: into l_step_value,l_prof_level_id
2859: from per_competences_vl, per_rating_levels
2860: where ((per_rating_levels.competence_id = per_competences_vl.competence_id or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2861: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value) );

Line 2859: from per_competences_vl, per_rating_levels

2855: if p_step_value is not null then
2856: hr_utility.set_location(l_proc,10);
2857: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2858: into l_step_value,l_prof_level_id
2859: from per_competences_vl, per_rating_levels
2860: where ((per_rating_levels.competence_id = per_competences_vl.competence_id or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2861: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value) );
2862: if sql%notfound then
2863: hr_utility.set_location(l_proc,15);

Line 2860: where ((per_rating_levels.competence_id = per_competences_vl.competence_id or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)

2856: hr_utility.set_location(l_proc,10);
2857: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2858: into l_step_value,l_prof_level_id
2859: from per_competences_vl, per_rating_levels
2860: where ((per_rating_levels.competence_id = per_competences_vl.competence_id or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2861: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value) );
2862: if sql%notfound then
2863: hr_utility.set_location(l_proc,15);
2864: raise g_invalid_competence;

Line 2861: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value) );

2857: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2858: into l_step_value,l_prof_level_id
2859: from per_competences_vl, per_rating_levels
2860: where ((per_rating_levels.competence_id = per_competences_vl.competence_id or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2861: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value) );
2862: if sql%notfound then
2863: hr_utility.set_location(l_proc,15);
2864: raise g_invalid_competence;
2865: end if;

Line 3685: per_rating_levels rl1, per_rating_levels rl2

3681: Cursor csr_bg_profrange is
3682: Select rl1.step_value || decode(rl1.name, '', '', ' ' || rl1.name) minprof,
3683: rl2.step_value || decode(rl2.name, '', '', ' ' || rl2.name) maxprof
3684: From per_competence_elements pce, per_all_assignments_f paaf,
3685: per_rating_levels rl1, per_rating_levels rl2
3686: Where paaf.person_id = p_person_id
3687: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3688: And pce.enterprise_id = paaf.business_group_id
3689: And pce.competence_id = p_competence_id

Line 3698: per_rating_levels rl1, per_rating_levels rl2

3694: Cursor csr_job_profrange is
3695: Select rl1.step_value || decode(rl1.name, '', '', ', ' || rl1.name) minprof,
3696: rl2.step_value || decode(rl2.name, '', '', ', ' || rl2.name) maxprof
3697: From per_competence_elements pce, per_all_assignments_f paaf,
3698: per_rating_levels rl1, per_rating_levels rl2
3699: Where paaf.person_id = p_person_id
3700: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3701: And pce.job_id = paaf.job_id
3702: And pce.competence_id = p_competence_id

Line 3711: per_rating_levels rl1, per_rating_levels rl2

3707: Cursor csr_pos_profrange is
3708: Select rl1.step_value || decode(rl1.name, '', '', ', ' || rl1.name) minprof,
3709: rl2.step_value || decode(rl2.name, '', '', ', ' || rl2.name) maxprof
3710: From per_competence_elements pce, per_all_assignments_f paaf,
3711: per_rating_levels rl1, per_rating_levels rl2
3712: Where paaf.person_id = p_person_id
3713: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3714: And pce.position_id = paaf.position_id
3715: And pce.competence_id = p_competence_id

Line 3724: per_rating_levels rl1, per_rating_levels rl2

3720: Cursor csr_org_profrange is
3721: Select rl1.step_value || decode(rl1.name, '', '', ', ' || rl1.name) minprof,
3722: rl2.step_value || decode(rl2.name, '', '', ', ' || rl2.name) maxprof
3723: From per_competence_elements pce, per_all_assignments_f paaf,
3724: per_rating_levels rl1, per_rating_levels rl2
3725: Where paaf.person_id = p_person_id
3726: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3727: And pce.organization_id = paaf.organization_id
3728: And pce.competence_id = p_competence_id