APPS.IRC_INP_BUS dependencies on PER_ALL_PEOPLE_F

Line 259: -- Validates if the person id exists in the PER_ALL_PEOPLE_F table

255: -- |---------------------------< chk_person_id >-------------------------------|
256: -- ----------------------------------------------------------------------------
257: --
258: -- Description:
259: -- Validates if the person id exists in the PER_ALL_PEOPLE_F table
260: --
261: -- Prerequisites:
262: -- Must be called as the first step in insert_validate.
263: --

Line 268: -- If the person_id is existing in PER_ALL_PEOPLE_F

264: -- In Arguments:
265: -- p_person_id
266: --
267: -- Post Success:
268: -- If the person_id is existing in PER_ALL_PEOPLE_F
269: -- then continue.
270: --
271: -- Post Failure:
272: -- If the person_id is not present in PER_ALL_PEOPLE_F

Line 272: -- If the person_id is not present in PER_ALL_PEOPLE_F

268: -- If the person_id is existing in PER_ALL_PEOPLE_F
269: -- then continue.
270: --
271: -- Post Failure:
272: -- If the person_id is not present in PER_ALL_PEOPLE_F
273: -- then throw an error indicating the same.
274: --
275: -- Access Status:
276: -- Internal Row Handler Use Only.

Line 289: from per_all_people_f

285: l_proc varchar2(72) := g_package||'chk_person_id';
286: l_party_id irc_notification_preferences.party_id%type;
287: cursor l_person is
288: select party_id
289: from per_all_people_f
290: where person_id = p_person_id
291: and p_effective_date between
292: effective_start_date and effective_end_date;
293: --