APPS.HR_DOCUMENT_EXTRA_INFO_SWI dependencies on PER_ALL_PEOPLE_F

Line 640: from per_all_people_f

636:
637: cursor c_person_exist (p_in_person_id in number,p_in_eff_date in date)
638: is
639: select person_id
640: from per_all_people_f
641: where person_id = p_in_person_id
642: and p_in_eff_date between effective_start_date and effective_end_date;
643:
644:

Line 656: from per_all_people_f

652: else
653: Begin
654: select to_char(trunc(min(effective_start_date)),'RRRR-MM-DD')
655: into l_start_date
656: from per_all_people_f
657: where person_id = p_in_person_id;
658: Exception
659: When others then
660: l_start_date := to_char(trunc(p_in_eff_date),'RRRR-MM-DD');