APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on PER_VAC_LINKED_ASSIGNMENTS

Line 52: per_vac_linked_assignments pvla

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
56: pav.vacancy_id = pvla.vacancy_id and

Line 89: from per_vac_linked_assignments

85: pil.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
86: ler.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
87: pVacancyId = nvl(paaf.vacancy_id,
88: (select vacancy_id
89: from per_vac_linked_assignments
90: where tgt_apl_asg_id = paaf.assignment_id
91: and sysdate between nvl(start_date,sysdate)
92: and nvl(end_date,sysdate) and rownum<2
93: )