DBA Data[Home] [Help]

APPS.HR_REPORTS dependencies on PER_ALL_PEOPLE_F

Line 1920: v_person_name per_all_people_f.full_name%type;

1916: (p_session_date date,
1917: p_person_id number) return varchar2
1918: --
1919: as
1920: v_person_name per_all_people_f.full_name%type;
1921: --
1922: begin
1923: --
1924: hr_utility.trace('entered hr_reports.get_person_name');

Line 1934: from per_all_people_f p

1930: begin
1931: hr_utility.set_location('hr_reports.get_person_name',10);
1932: select p.full_name
1933: into v_person_name
1934: from per_all_people_f p
1935: where p.person_id = p_person_id
1936: and p_session_date between p.effective_start_date
1937: and p.effective_end_date;
1938: exception