DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on PER_ALL_VACANCIES

Line 1650: per_all_vacancies x

1646: return number is
1647: cursor c1 is
1648: select min(r.vacancy_id)
1649: from per_recruitment_activity_for r,
1650: per_all_vacancies x
1651: where r.recruitment_activity_id = p_recruitment_activity_id
1652: and r.vacancy_id = x.vacancy_id
1653: and p_date_received between x.date_from
1654: and nvl(x.date_to,p_date_received)

Line 1768: from per_all_vacancies x

1764: x.grade_id,
1765: x.location_id,
1766: x.recruiter_id,
1767: x.manager_id -- added for bug 8678206
1768: from per_all_vacancies x
1769: where x.vacancy_id = p_vacancy_id ;
1770: --
1771: cursor get_organization is
1772: select xtl.name