APPS.BEN_EXT_XML_WRITE dependencies on PER_ALL_PEOPLE_F

Line 1600: from per_all_people_f

1596:
1597: cursor c_per_info (p_person_id number, p_effective_date date) is
1598: select full_name,
1599: employee_number
1600: from per_all_people_f
1601: where person_id = p_person_id
1602: and p_effective_date between EFFECTIVE_START_DATE and
1603: nvl(EFFECTIVE_END_DATE,trunc(sysdate));
1604: l_name per_all_people_f.full_name%type ;

Line 1604: l_name per_all_people_f.full_name%type ;

1600: from per_all_people_f
1601: where person_id = p_person_id
1602: and p_effective_date between EFFECTIVE_START_DATE and
1603: nvl(EFFECTIVE_END_DATE,trunc(sysdate));
1604: l_name per_all_people_f.full_name%type ;
1605: l_employee_number per_all_people_f.employee_number%type ;
1606:
1607: --
1608: l_proc varchar2(72) := g_package||'main';

Line 1605: l_employee_number per_all_people_f.employee_number%type ;

1601: where person_id = p_person_id
1602: and p_effective_date between EFFECTIVE_START_DATE and
1603: nvl(EFFECTIVE_END_DATE,trunc(sysdate));
1604: l_name per_all_people_f.full_name%type ;
1605: l_employee_number per_all_people_f.employee_number%type ;
1606:
1607: --
1608: l_proc varchar2(72) := g_package||'main';
1609: l_max_ext_line_size Number := 32767 ;