APPS.PER_DB_PER_ADDITIONAL dependencies on PER_VACANCIES

Line 1083: FROM per_vacancies

1079: , l_organization_id
1080: , l_grade_id
1081: , l_people_group_id
1082: , l_location_id
1083: FROM per_vacancies
1084: WHERE name = p_vacancy
1085: AND l_effective_start_date BETWEEN date_from
1086: AND nvl(date_to,to_date('4712/12/31','YYYY/MM/DD'));
1087: --

Line 2046: FROM per_vacancies

2042: , l_organization_id
2043: , l_grade_id
2044: , l_people_group_id
2045: , l_location_id
2046: FROM per_vacancies
2047: WHERE name = p_vacancy
2048: AND l_effective_start_date BETWEEN date_from
2049: AND nvl(date_to,to_date('4712/12/31','YYYY/MM/DD'));
2050: --