APPS.PER_CPN_BUS dependencies on PER_RATING_LEVELS

Line 934: from per_rating_levels

930: -- Cursor to check if competence has Proficiency levels
931: --
932: cursor csr_comp_has_prof_levels is
933: select 'Y'
934: from per_rating_levels
935: where competence_id = p_competence_id;
936: --
937: begin
938: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1023: from per_rating_levels rl,

1019: -- change made to fix bug 569647 (added competence_id)
1020: --
1021: cursor csr_rating_level_in_ele is
1022: select 'Y'
1023: from per_rating_levels rl,
1024: per_competence_elements ce
1025: where ((rl.rating_level_id = ce.proficiency_level_id) or
1026: (rl.rating_level_id = ce.high_proficiency_level_id))
1027: and rl.rating_scale_id = nvl(per_cpn_shd.g_old_rec.rating_scale_id,-9999)

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

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

Line 1124: from per_rating_levels

1120: -- Cursor to check if competence is used in per_rating_levels
1121: --
1122: cursor csr_chk_comp_exists_in_rl is
1123: select 'Y'
1124: from per_rating_levels
1125: where competence_id = p_competence_id;
1126: --
1127: -- Cursor to check if competence is used in per_competende_outcomes
1128: --

Line 1207: from per_rating_levels

1203: -- levels
1204: --
1205: cursor c_competence_levels is
1206: select 1
1207: from per_rating_levels
1208: where competence_id = p_competence_id;
1209: --
1210: -- variables
1211: --