APPS.BEN_EDR_BUS dependencies on PER_PERSON_TYPES

Line 145: from per_person_types a

141: ;
142: --
143: cursor c1 is
144: select system_person_type
145: from per_person_types a
146: where a.person_type_id =to_number( p_reason)
147: and a.business_group_id = p_business_group_id;
148: --
149: cursor c2 is

Line 196: -- check if reason value exists in per_person_types table

192: and nvl(p_reason,hr_api.g_number)
193: <> nvl(ben_edr_shd.g_old_rec.reason,hr_api.g_number)
194: or not l_api_updating) then
195: --
196: -- check if reason value exists in per_person_types table
197: --
198: open c1;
199: --
200: fetch c1 into l_system_person_type;

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

201: if c1%notfound then
202: --
203: close c1;
204: --
205: -- raise error as FK does not relate to PK in per_person_types
206: -- table.
207: --
208: ben_edr_shd.constraint_error('BEN_ELIG_dsblty_rsn_PRTE_FK2');
209: --

Line 293: from per_person_types ppt

289: l_dummy varchar2(1);
290: --
291: cursor c1 is
292: select null
293: from per_person_types ppt
294: where ppt.system_person_type = p_reason
295: and ppt.active_flag = 'Y'
296: and ppt.business_group_id+0 = p_business_group_id;
297: --