[Home] [Help]
26: paaf.vacancy_id = vac.Vacancy_Id and
27: paaf.assignment_type = 'E' AND
28: paaf.primary_flag='Y' and
29: sysdate BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND
30: NOT EXISTS ( SELECT ben.person_id FROM ben_prtt_enrt_rslt_f ben
31: where paaf.person_id = ben.person_id) AND
32: ler.typ_cd = 'IREC' AND
33: pil.LF_EVT_OCRD_DT BETWEEN ler.effective_start_date(+) AND ler.effective_end_date(+) and
34: ler.ler_id = pil.ler_id AND
53: paaf.vacancy_id = pVacancyId and
54: paaf.assignment_type = 'E' AND
55: paaf.primary_flag='Y' and
56: sysdate BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND
57: NOT EXISTS ( SELECT ben.person_id FROM ben_prtt_enrt_rslt_f ben
58: where paaf.person_id = ben.person_id) and
59: ler.typ_cd = 'IREC' AND
60: pil.LF_EVT_OCRD_DT BETWEEN ler.effective_start_date(+) AND ler.effective_end_date(+) and
61: ler.ler_id = pil.ler_id AND
512: paaf.primary_flag='Y' and
513: pil.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
514: ler.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
515: SYSDATE BETWEEN PAAF.effective_start_date AND PAAF.effective_end_date AND
516: NOT EXISTS ( SELECT ben.person_id FROM ben_prtt_enrt_rslt_f ben
517: where paaf.person_id = ben.person_id AND ROWNUM = 1) AND
518: ler.typ_cd = 'IREC' AND
519: pil.LF_EVT_OCRD_DT BETWEEN ler.effective_start_date(+) AND ler.effective_end_date(+) and
520: ler.ler_id = pil.ler_id AND pil.person_id=paaf.person_id AND
588: l_hire_date DATE;
589: l_proc varchar2(80) default g_package||'.run_enrollment';
590: cursor c_participation is
591: select prtt_enrt_rslt_id
592: from ben_prtt_enrt_rslt_f
593: where person_id = pPersonId;
594: BEGIN
595: --
596: hr_utility.set_location('Entering '||l_proc, 10);