APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on PER_ALL_VACANCIES

Line 51: per_all_vacancies pav,

47: PIL.PER_IN_LER_ID, PAAF.BUSINESS_GROUP_ID
48: FROM
49: per_all_assignments_f paaf,
50: BEN_PER_IN_LER pil, ben_ler_f ler,
51: per_all_vacancies pav,
52: per_vac_linked_assignments pvla
53: WHERE
54: pvla.tgt_apl_asg_id = paaf.assignment_id and
55: sysdate between nvl(pvla.start_date,sysdate) and nvl(pvla.end_date,sysdate) and

Line 168: from per_all_vacancies

164: --
165: l_dummy varchar2(30);
166: cursor c_vacancy_name is
167: select name
168: from per_all_vacancies
169: where vacancy_id = p_vacancy_id;
170: --
171: begin
172: --