APPS.PER_CPN_BUS dependencies on PER_RATING_LEVELS

Line 928: from per_rating_levels

924: -- Cursor to check if competence has Proficiency levels
925: --
926: cursor csr_comp_has_prof_levels is
927: select 'Y'
928: from per_rating_levels
929: where competence_id = p_competence_id;
930: --
931: begin
932: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1017: from per_rating_levels rl,

1013: -- change made to fix bug 569647 (added competence_id)
1014: --
1015: cursor csr_rating_level_in_ele is
1016: select 'Y'
1017: from per_rating_levels rl,
1018: per_competence_elements ce
1019: where ((rl.rating_level_id = ce.proficiency_level_id) or
1020: (rl.rating_level_id = ce.high_proficiency_level_id))
1021: and rl.rating_scale_id = nvl(per_cpn_shd.g_old_rec.rating_scale_id,-9999)

Line 1114: -- Cursor to check if competence is used in per_rating_levels

1110: select 'Y'
1111: from per_competence_elements
1112: where competence_id = p_competence_id;
1113: --
1114: -- Cursor to check if competence is used in per_rating_levels
1115: --
1116: cursor csr_chk_comp_exists_in_rl is
1117: select 'Y'
1118: from per_rating_levels

Line 1118: from per_rating_levels

1114: -- Cursor to check if competence is used in per_rating_levels
1115: --
1116: cursor csr_chk_comp_exists_in_rl is
1117: select 'Y'
1118: from per_rating_levels
1119: where competence_id = p_competence_id;
1120: --
1121: -- Cursor to check if competence is used in per_competende_outcomes
1122: --

Line 1201: from per_rating_levels

1197: -- levels
1198: --
1199: cursor c_competence_levels is
1200: select 1
1201: from per_rating_levels
1202: where competence_id = p_competence_id;
1203: --
1204: -- variables
1205: --