195: l_dummy varchar2(1);
196: --
197: cursor c1 is
198: select null
199: from per_qualifications per
200: where per.qualification_type_id = p_qualification_type_id;
201: --
202: Begin
203: --
209: --
210: if c1%found then
211: --
212: -- error cannot delete qualification_type_id as it is used in the
213: -- per_qualifications table
214: --
215: close c1;
216: hr_utility.set_message(801,'HR_51537_EQT_QUAL_TAB_REF');
217: hr_utility.raise_error;