DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on PER_VACANCIES

Line 1704: l_manager_id per_vacancies.manager_id%TYPE;

1700: p_location_code in out nocopy varchar2,
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

Line 2003: l_manager_id per_vacancies.manager_id%TYPE;

1999: p_location_code in out nocopy varchar2) is
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: