DBA Data[Home] [Help]

APPS.HR_APPLICANT_API dependencies on PER_ALL_VACANCIES

Line 1711: from per_all_vacancies vac

1707: -- end of bug 4681211
1708: --
1709: cursor csr_vacs(p_vacancy_id number) is
1710: select 1
1711: from per_all_vacancies vac
1712: where vac.vacancy_id=p_vacancy_id
1713: and vac.number_of_openings <
1714: (select count(distinct assignment_id)
1715: from per_all_assignments_f asg