APPS.BEN_BLI_BUS dependencies on PER_ALL_PEOPLE_F

Line 193: from per_all_people_f a

189: l_dummy varchar2(1);
190: --
191: cursor c1 is
192: select null
193: from per_all_people_f a
194: where a.person_id = p_person_id
195: and p_effective_date
196: between a.effective_start_date
197: and a.effective_end_date;

Line 212: -- check if person_id value exists in per_all_people_f table

208: and nvl(p_person_id,hr_api.g_number)
209: <> nvl(ben_bli_shd.g_old_rec.person_id,hr_api.g_number)
210: or not l_api_updating) then
211: --
212: -- check if person_id value exists in per_all_people_f table
213: --
214: open c1;
215: --
216: fetch c1 into l_dummy;

Line 221: -- raise error as FK does not relate to PK in per_all_people_f

217: if c1%notfound then
218: --
219: close c1;
220: --
221: -- raise error as FK does not relate to PK in per_all_people_f
222: -- table.
223: --
224: ben_bli_shd.constraint_error('BEN_BATCH_LER_INFO_DT1');
225: --