DBA Data[Home] [Help]

APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on PER_VACANCIES

Line 23: PER_VACANCIES vac, per_all_assignments_f paaf,

19: SELECT
20: vac.VACANCY_ID,paaf.person_id,paaf.assignment_id,
21: PIL.PER_IN_LER_ID, PAAF.BUSINESS_GROUP_ID
22: FROM
23: PER_VACANCIES vac, per_all_assignments_f paaf,
24: BEN_PER_IN_LER pil, ben_ler_f ler
25: WHERE
26: vac.BUSINESS_GROUP_ID = pBGId and
27: paaf.BUSINESS_GROUP_ID = vac.BUSINESS_GROUP_ID and