138: -- BUG3356369
139: --
140: cursor c2 is
141: select null
142: from per_competence_elements comp
143: where comp.qualification_type_id = p_qualification_type_id;
144: Begin
145: --
146: hr_utility.set_location('Entering:'||l_proc, 5);
170: --
171: if c2%found then
172: --
173: -- error cannot delete qualification_type_id as it is used in the
174: -- per_competence_elements table
175: --
176: close c2;
177: hr_utility.set_message(800,'HR_449133_QUA_FWK_EQT_TAB_REF');
178: hr_utility.raise_error;