DBA Data[Home] [Help]

APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on PER_ALL_VACANCIES

Line 19: PER_ALL_VACANCIES vac, per_all_assignments_f paaf,

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

Line 124: from per_all_vacancies

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: --