APPS.PER_APPLICANT_PKG dependencies on PER_ALL_PEOPLE

Line 1546: from per_all_people per

1542: --
1543: cursor get_recruiter is
1544: select per.full_name
1545: ,per.employee_number
1546: from per_all_people per
1547: where per.person_id = p_recruiter_id;
1548: --
1549: cursor get_job is
1550: select x.name

Line 1663: l_recruiter_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;

1659: p_grade_name in out nocopy varchar2,
1660: p_location_id in out nocopy number,
1661: p_location_code in out nocopy varchar2) is
1662:
1663: l_recruiter_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
1664:
1665: begin
1666: get_vacancy_details (p_vacancy_id => p_vacancy_id,
1667: p_vacancy_name => p_vacancy_name,

Line 1702: l_recruiter_number PER_ALL_PEOPLE.EMPLOYEE_NUMBER%TYPE;

1698: p_grade_id in out nocopy number,
1699: p_grade_name in out nocopy varchar2,
1700: p_location_id in out nocopy number,
1701: p_location_code in out nocopy varchar2 ) is
1702: l_recruiter_number PER_ALL_PEOPLE.EMPLOYEE_NUMBER%TYPE;
1703:
1704: begin
1705: --
1706: -- Check that the vacancy is unique

Line 1842: FROM PER_ALL_PEOPLE_F

1838: p_applicant_number in number ) is
1839: l_dummy_number number ;
1840: cursor c1 is
1841: SELECT 1
1842: FROM PER_ALL_PEOPLE_F
1843: WHERE APPLICANT_NUMBER = p_applicant_number
1844: AND business_group_id + 0 = p_business_group_id ;
1845: begin
1846: --

Line 1864: from per_all_people_f

1860: --
1861: l_dummy_number number := NULL ;
1862: cursor c1 is
1863: select 1
1864: from per_all_people_f
1865: where person_id = p_person_id
1866: group by person_id having count(*) > 1 ;
1867: --
1868: cursor c2 is