APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on BEN_LER_F

Line 24: BEN_PER_IN_LER pil, ben_ler_f ler

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
28: pil.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and

Line 50: BEN_PER_IN_LER pil, ben_ler_f ler,

46: pav.vacancy_id,paaf.person_id,paaf.assignment_id,
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

Line 83: per_all_assignments_f paaf,BEN_PER_IN_LER pil, ben_ler_f ler

79: SELECT
80: paaf.person_id, paaf.assignment_id, PIL.PER_IN_LER_ID,
81: PAAF.BUSINESS_GROUP_ID
82: FROM
83: per_all_assignments_f paaf,BEN_PER_IN_LER pil, ben_ler_f ler
84: WHERE
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,

Line 557: from per_all_assignments_f PAAF, BEN_PER_IN_LER pil, ben_ler_f ler

553: l_business_group_id NUMBER;
554: l_description varchar2(500);
555: cursor csr_assignment is
556: select PAAF.assignment_id,PAAF.BUSINESS_GROUP_ID,PIL.PER_IN_LER_ID
557: from per_all_assignments_f PAAF, BEN_PER_IN_LER pil, ben_ler_f ler
558: where PAAF.person_id = pPersonId and PAAF.assignment_type='E' and
559: paaf.primary_flag='Y' and
560: pil.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
561: ler.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and