APPS.BEN_EPT_BUS dependencies on PER_PERSON_TYPES

Line 38: from per_person_types ppt

34: where b.eligy_prfl_id = p_eligy_prfl_id;
35:
36: cursor c2 is
37: select ppt.system_person_type
38: from per_person_types ppt
39: where ppt.person_type_id = p_person_type_id;
40:
41: --
42: Begin

Line 217: from per_person_types a

213:
214: --
215: cursor c1 is
216: select system_person_type
217: from per_person_types a
218: where a.person_type_id =to_number( p_per_typ_cd)
219: and a.business_group_id = p_business_group_id;
220: --
221: cursor c2 is

Line 268: -- check if per_typ_cd value exists in per_person_types table

264: and nvl(p_per_typ_cd,hr_api.g_number)
265: <> nvl(ben_ept_shd.g_old_rec.per_typ_cd,hr_api.g_number)
266: or not l_api_updating) then
267: --
268: -- check if per_typ_cd value exists in per_person_types table
269: --
270: open c1;
271: --
272: fetch c1 into l_system_person_type;

Line 277: -- raise error as FK does not relate to PK in per_person_types

273: if c1%notfound then
274: --
275: close c1;
276: --
277: -- raise error as FK does not relate to PK in per_person_types
278: -- table.
279: --
280: ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');
281: --

Line 372: from per_person_types ppt

368: --
369: /* --
370: cursor c1 is
371: select null
372: from per_person_types ppt
373: where ppt.system_person_type = p_per_typ_cd
374: and ppt.active_flag = 'Y'
375: and ppt.business_group_id+0 = p_business_group_id;
376: -- */

Line 380: from per_person_types ppt

376: -- */
377: --
378: cursor c1 is
379: select null
380: from per_person_types ppt
381: where ppt.person_type_id = p_person_type_id
382: and ppt.active_flag = 'Y'
383: and ppt.business_group_id+0 = p_business_group_id;
384: --