DBA Data[Home] [Help]

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_ALL_VACANCIES

Line 833: from per_all_vacancies vac

829: l_dummy number;
830: --
831: cursor csr_vacs(p_vacancy_id number) is
832: select 1
833: from per_all_vacancies vac
834: where vac.vacancy_id=p_vacancy_id
835: and vac.number_of_openings <
836: (select count(distinct assignment_id)
837: from per_all_assignments_f asg

Line 1711: from per_all_vacancies vac

1707: l_primary_cag_rec per_cagr_grades_def%rowtype;
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