APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 34: NOT EXISTS ( SELECT ben.person_id FROM ben_prtt_enrt_rslt_f ben

30: paaf.vacancy_id = vac.Vacancy_Id and
31: paaf.assignment_type = 'E' AND
32: paaf.primary_flag='Y' and
33: sysdate BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND
34: NOT EXISTS ( SELECT ben.person_id FROM ben_prtt_enrt_rslt_f ben
35: where paaf.person_id = ben.person_id) AND
36: ler.typ_cd = 'IREC' AND
37: pil.LF_EVT_OCRD_DT BETWEEN ler.effective_start_date(+) AND ler.effective_end_date(+) and
38: ler.ler_id = pil.ler_id AND

Line 63: NOT EXISTS ( SELECT ben.person_id FROM ben_prtt_enrt_rslt_f ben

59: ler.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
60: paaf.assignment_type = 'E' AND
61: paaf.primary_flag='Y' and
62: sysdate BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND
63: NOT EXISTS ( SELECT ben.person_id FROM ben_prtt_enrt_rslt_f ben
64: where paaf.person_id = ben.person_id) AND
65: ler.typ_cd = 'IREC' AND
66: pil.LF_EVT_OCRD_DT BETWEEN ler.effective_start_date(+) AND ler.effective_end_date(+) and
67: ler.ler_id = pil.ler_id AND

Line 98: NOT EXISTS ( SELECT ben.person_id FROM ben_prtt_enrt_rslt_f ben

94: ) and
95: paaf.assignment_type = 'E' AND
96: paaf.primary_flag='Y' and
97: sysdate BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND
98: NOT EXISTS ( SELECT ben.person_id FROM ben_prtt_enrt_rslt_f ben
99: where paaf.person_id = ben.person_id) and
100: ler.typ_cd = 'IREC' AND
101: pil.LF_EVT_OCRD_DT BETWEEN ler.effective_start_date(+) AND ler.effective_end_date(+) and
102: ler.ler_id = pil.ler_id AND

Line 563: NOT EXISTS ( SELECT ben.person_id FROM ben_prtt_enrt_rslt_f ben

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
562: SYSDATE BETWEEN PAAF.effective_start_date AND PAAF.effective_end_date AND
563: NOT EXISTS ( SELECT ben.person_id FROM ben_prtt_enrt_rslt_f ben
564: where paaf.person_id = ben.person_id AND ROWNUM = 1) AND
565: ler.typ_cd = 'IREC' AND
566: pil.LF_EVT_OCRD_DT BETWEEN ler.effective_start_date(+) AND ler.effective_end_date(+) and
567: ler.ler_id = pil.ler_id AND pil.person_id=paaf.person_id AND

Line 639: from ben_prtt_enrt_rslt_f

635: l_hire_date DATE;
636: l_proc varchar2(80) default g_package||'.run_enrollment';
637: cursor c_participation is
638: select prtt_enrt_rslt_id
639: from ben_prtt_enrt_rslt_f
640: where person_id = pPersonId;
641: BEGIN
642: --
643: hr_utility.set_location('Entering '||l_proc, 10);