DBA Data[Home] [Help]

APPS.HR_BIS_ALERTS dependencies on PER_VACANCIES

Line 2642: FROM per_vacancies v

2638: ,p_c_period_end_date DATE)
2639: IS
2640: SELECT v.budget_measurement_value
2641: , v.vacancy_id
2642: FROM per_vacancies v
2643: WHERE ( (p_c_actual_rec.dim2_level_value_name = 'JOB CATEGORY'
2644: AND v.job_id IN
2645: (SELECT jei.job_id
2646: FROM per_job_extra_info jei