APPS.IRC_ILC_BUS dependencies on PER_ALL_PEOPLE_F

Line 249: -- This procedure is used to ensure that party_id exists in PER_ALL_PEOPLE_F

245: -- ----------------------------------------------------------------------------
246: -- {Start Of Comments}
247: --
248: -- Description:
249: -- This procedure is used to ensure that party_id exists in PER_ALL_PEOPLE_F
250: --
251: -- Pre Conditions:
252: --
253: -- In Arguments:

Line 274: from per_all_people_f ppf

270: l_party_id varchar2(1);
271: --
272: cursor csr_party_id is
273: select null
274: from per_all_people_f ppf
275: where ppf.party_id = p_party_id
276: and trunc(p_effective_date) between ppf.effective_start_date
277: and ppf.effective_end_date;
278: --

Line 281: -- Check that Party_ID(Object_id) exists in per_all_people_f

277: and ppf.effective_end_date;
278: --
279: begin
280: hr_utility.set_location('Entering:'||l_proc,10);
281: -- Check that Party_ID(Object_id) exists in per_all_people_f
282: open csr_party_id;
283: fetch csr_party_id into l_party_id;
284: hr_utility.set_location(l_proc,20);
285: if csr_party_id%NOTFOUND then