APPS.PER_APPLICANT_PKG dependencies on PER_ALL_PEOPLE_F

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 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