APPS.HR_DEI_BUS dependencies on PER_PEOPLE_F

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

939: -- |---------------------------< chk_person_id >----------------------------|
940: -- ---------------------------------------------------------------------------
941: --
942: -- Description:
943: -- - Validates that a person id exists in table per_people_f.
944: -- - Validates that the business group of the address matches
945: -- the business group of the person.
946: --
947: -- Pre-conditions:

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

951: -- p_person_id
952: --
953: --
954: -- Post Success:
955: -- If a row does exist in per_people_f for the given person id then
956: -- processing continues.
957: --
958: -- Post Failure:
959: -- If a row does not exist in per_people_f for the given person id then

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

955: -- If a row does exist in per_people_f for the given person id then
956: -- processing continues.
957: --
958: -- Post Failure:
959: -- If a row does not exist in per_people_f for the given person id then
960: -- an application error will be raised and processing is terminated.
961: --
962: -- Access Status:
963: -- Internal Table Handler Use Only.

Line 981: from per_people_f ppf

977: l_person_id number;
978: --
979: cursor csr_valid_pers is
980: select person_id
981: from per_people_f ppf
982: where ppf.person_id = p_person_id;
983: --
984: begin
985: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 997: -- valid person on PER_PEOPLE_F

993: );
994: --
995: --
996: -- Check that the Person ID is linked to a
997: -- valid person on PER_PEOPLE_F
998: --
999: open csr_valid_pers;
1000: fetch csr_valid_pers into l_person_id;
1001: if csr_valid_pers%notfound then