APPS.IRC_JBI_BUS dependencies on PER_ALL_PEOPLE_F

Line 25: -- If the person id is not found in per_all_people_f an error is generated.

21: -- {Start Of Comments}
22: --
23: -- Description:
24: -- This procedure is used to ensure that mandatory parameters have been set.
25: -- If the person id is not found in per_all_people_f an error is generated.
26: --
27: -- Pre Conditions:
28: -- g_old_rec has been populated with details of the values currently in
29: -- the database.

Line 56: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F.

52: l_party_id irc_job_basket_items.party_id%type;
53: l_var varchar2(30);
54: --
55: --
56: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F.
57: --
58: cursor csr_person_id is
59: select party_id
60: from per_all_people_f

Line 60: from per_all_people_f

56: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F.
57: --
58: cursor csr_person_id is
59: select party_id
60: from per_all_people_f
61: where person_id = p_person_id
62: and p_effective_date between effective_start_date
63: and effective_end_date;
64: --

Line 70: -- Check if the person_id exists in PER_ALL_PEOPLE_F.

66: --
67: hr_utility.set_location(' Entering:'||l_proc,10);
68: --
69: --
70: -- Check if the person_id exists in PER_ALL_PEOPLE_F.
71: --
72: open csr_person_id;
73: fetch csr_person_id into l_party_id;
74: hr_utility.set_location(l_proc, 30);