15: SELECT
16: vac.VACANCY_ID,paaf.person_id,paaf.assignment_id,
17: PIL.PER_IN_LER_ID, PAAF.BUSINESS_GROUP_ID
18: FROM
19: PER_ALL_VACANCIES vac, per_all_assignments_f paaf,
20: BEN_PER_IN_LER pil, ben_ler_f ler
21: WHERE
22: vac.BUSINESS_GROUP_ID = pBGId and
23: paaf.BUSINESS_GROUP_ID = vac.BUSINESS_GROUP_ID and
120: --
121: l_dummy varchar2(30);
122: cursor c_vacancy_name is
123: select name
124: from per_all_vacancies
125: where vacancy_id = p_vacancy_id;
126: --
127: begin
128: --