APPS.HR_CONTACT_REL_API dependencies on PER_ALL_PEOPLE_F

Line 783: from per_all_people_f per

779: );
780: -- 1766066 end.
781: -- 2410386 start
782: select per.object_version_number into l_per_object_version_number
783: from per_all_people_f per
784: where per.person_id=l_contact_person_id_save
785: and p_start_date between per.effective_start_date and per.effective_end_date;
786: -- 2410386 end
787: --

Line 1590: from per_all_people_f

1586: --
1587: cursor csr_person_details(p_person_id number) is
1588: select object_version_number
1589: ,effective_start_date
1590: from per_all_people_f
1591: where person_id = p_person_id
1592: and effective_end_date = hr_general.end_of_time;
1593: --
1594: cursor csr_contact_person is