APPS.IRC_PARTY_SWI dependencies on PER_ALL_PEOPLE_F

Line 109: from per_all_people_f

105: l_person_ovn number;
106: --
107: cursor csr_person_ovn(p_person_id number) is
108: select object_version_number
109: from per_all_people_f
110: where person_id = p_person_id;
111: --
112: -- Variables for IN/OUT parameters
113: --

Line 550: ,p_per_information4 in per_all_people_f.per_information4%type default null

546: ,p_assignment_id in number
547: ,p_application_received_date in date default null
548: ,p_vacancy_id in number default null
549: ,p_posting_content_id in number default null
550: ,p_per_information4 in per_all_people_f.per_information4%type default null
551: ,p_per_object_version_number out nocopy number
552: ,p_asg_object_version_number out nocopy number
553: ,p_recruitment_person_ovn out nocopy number
554: ,p_applicant_number out nocopy varchar2

Line 571: from per_all_people_f

567: --
568: cursor csr_person_ovn(p_person_id number
569: ,p_effective_date date) is
570: select object_version_number
571: from per_all_people_f
572: where person_id = p_person_id
573: and p_effective_date between effective_start_date and effective_end_date;
574: --
575: Begin