DBA Data[Home] [Help]

APPS.HR_APPLICANT_API dependencies on PER_ALL_VACANCIES

Line 2117: from per_all_vacancies vac

2113: -- end of bug 4681211
2114: --
2115: cursor csr_vacs(p_vacancy_id number) is
2116: select 1
2117: from per_all_vacancies vac
2118: where vac.vacancy_id=p_vacancy_id
2119: and vac.number_of_openings <
2120: (select count(distinct assignment_id)
2121: from per_all_assignments_f asg