APPS.PER_QUA_BUS dependencies on PER_QUALIFICATION_TYPES

Line 250: from per_qualification_types per

246: l_dummy varchar2(1);
247: --
248: cursor c1 is
249: select null
250: from per_qualification_types per
251: where per.qualification_type_id = p_qualification_type_id;
252: --
253: Begin
254: --

Line 266: -- check if qualification type exist in per_qualification_types table

262: and nvl(p_qualification_type_id,hr_api.g_number)
263: <> nvl(per_qua_shd.g_old_rec.qualification_type_id,hr_api.g_number)
264: or not l_api_updating) then
265: --
266: -- check if qualification type exist in per_qualification_types table
267: --
268: open c1;
269: --
270: fetch c1 into l_dummy;

Line 275: -- raise error as FK does not relate to PK in per_qualification_types

271: if c1%notfound then
272: --
273: close c1;
274: --
275: -- raise error as FK does not relate to PK in per_qualification_types
276: -- table.
277: --
278: per_qua_shd.constraint_error('PER_QUALIFICATIONS_FK2');
279: --