APPS.PER_APPLICANT_PKG dependencies on PER_ALL_PEOPLE_F

Line 1705: l_manager_name per_all_people_f.full_name%TYPE;

1701: p_recruiter_number in out nocopy varchar2 ) is
1702:
1703: l_proc varchar2(20) := 'get_vacancy_details';
1704: l_manager_id per_vacancies.manager_id%TYPE;
1705: l_manager_name per_all_people_f.full_name%TYPE;
1706: l_manager_number per_all_people_f.employee_number%TYPE;
1707:
1708: begin
1709: --

Line 1706: l_manager_number per_all_people_f.employee_number%TYPE;

1702:
1703: l_proc varchar2(20) := 'get_vacancy_details';
1704: l_manager_id per_vacancies.manager_id%TYPE;
1705: l_manager_name per_all_people_f.full_name%TYPE;
1706: l_manager_number per_all_people_f.employee_number%TYPE;
1707:
1708: begin
1709: --
1710: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);

Line 1960: l_recruiter_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;

1956: p_grade_name in out nocopy varchar2,
1957: p_location_id in out nocopy number,
1958: p_location_code in out nocopy varchar2) is
1959:
1960: l_recruiter_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
1961:
1962: begin
1963: get_vacancy_details (p_vacancy_id => p_vacancy_id,
1964: p_vacancy_name => p_vacancy_name,

Line 2004: l_manager_name per_all_people_f.full_name%TYPE;

2000:
2001: --
2002: l_proc varchar2(20):= 'set_vac_from_rec_act';
2003: l_manager_id per_vacancies.manager_id%TYPE;
2004: l_manager_name per_all_people_f.full_name%TYPE;
2005: l_manager_number per_all_people_f.employee_number%TYPE;
2006: --
2007:
2008: begin

Line 2005: l_manager_number per_all_people_f.employee_number%TYPE;

2001: --
2002: l_proc varchar2(20):= 'set_vac_from_rec_act';
2003: l_manager_id per_vacancies.manager_id%TYPE;
2004: l_manager_name per_all_people_f.full_name%TYPE;
2005: l_manager_number per_all_people_f.employee_number%TYPE;
2006: --
2007:
2008: begin
2009: --

Line 2235: FROM PER_ALL_PEOPLE_F

2231: p_applicant_number in number ) is
2232: l_dummy_number number ;
2233: cursor c1 is
2234: SELECT 1
2235: FROM PER_ALL_PEOPLE_F
2236: WHERE APPLICANT_NUMBER = p_applicant_number
2237: AND business_group_id + 0 = p_business_group_id ;
2238: begin
2239: --

Line 2257: from per_all_people_f

2253: --
2254: l_dummy_number number := NULL ;
2255: cursor c1 is
2256: select 1
2257: from per_all_people_f
2258: where person_id = p_person_id
2259: group by person_id having count(*) > 1 ;
2260: --
2261: cursor c2 is