DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on PER_ALL_VACANCIES

Line 1483: per_all_vacancies x

1479: return number is
1480: cursor c1 is
1481: select min(r.vacancy_id)
1482: from per_recruitment_activity_for r,
1483: per_all_vacancies x
1484: where r.recruitment_activity_id = p_recruitment_activity_id
1485: and r.vacancy_id = x.vacancy_id
1486: and p_date_received between x.date_from
1487: and nvl(x.date_to,p_date_received)

Line 1532: from per_all_vacancies x

1528: x.position_id,
1529: x.grade_id,
1530: x.location_id,
1531: x.recruiter_id
1532: from per_all_vacancies x
1533: where x.vacancy_id = p_vacancy_id ;
1534: --
1535: cursor get_organization is
1536: select xtl.name