[Home] [Help]
208: ||';'
209: from per_all_vacancies pav,
210: per_jobs pj,
211: hr_all_positions_f pp,
212: per_recruitment_activities pra,
213: irc_posting_contents_vl ipc
214: where vacancy_id = c_vacancyId
215: and pav.job_id = pj.job_id(+)
216: and pav.position_id = pp.position_id(+)