APPS.PER_KAD_BUS dependencies on PER_PEOPLE_F

Line 22: -- Validates that a person id exists in table per_people_f.

18: -- |---------------------------< chk_person_id >----------------------------|
19: -- ---------------------------------------------------------------------------
20: --
21: -- Description:
22: -- Validates that a person id exists in table per_people_f.
23: --
24: -- Pre-conditions:
25: -- None.
26: --

Line 31: -- If a row does exist in per_people_f for the given person id then

27: -- In Arguments:
28: -- p_person_id
29: --
30: -- Post Success:
31: -- If a row does exist in per_people_f for the given person id then
32: -- processing continues.
33: --
34: -- Post Failure:
35: -- If a row does not exist in per_people_f for the given person id then

Line 35: -- If a row does not exist in per_people_f for the given person id then

31: -- If a row does exist in per_people_f for the given person id then
32: -- processing continues.
33: --
34: -- Post Failure:
35: -- If a row does not exist in per_people_f for the given person id then
36: -- an application error will be raised and processing is terminated.
37: --
38: -- Access Status:
39: -- Internal Table Handler Use Only.

Line 51: from per_people_f ppf

47: l_proc varchar2(72) := g_package||'chk_person_id';
48: --
49: cursor csr_valid_pers is
50: select null
51: from per_people_f ppf
52: where ppf.person_id = p_person_id;
53: --
54: begin
55: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 67: -- valid person on PER_PEOPLE_F

63: );
64: hr_utility.set_location(l_proc, 2);
65: --
66: -- Check that the Person ID is linked to a
67: -- valid person on PER_PEOPLE_F
68: --
69: open csr_valid_pers;
70: fetch csr_valid_pers into l_exists;
71: if csr_valid_pers%notfound then