DBA Data[Home] [Help]

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 1583: from per_all_people_f

1579: --
1580: cursor csr_person_details(p_person_id number) is
1581: select object_version_number
1582: ,effective_start_date
1583: from per_all_people_f
1584: where person_id = p_person_id
1585: and effective_end_date = hr_general.end_of_time;
1586: --
1587: cursor csr_contact_person is