APPS.BEN_AUTOMATIC_ENROLLMENTS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 572: ben_pil_elctbl_chc_popl pel

568: 'N' suspended,
569: epe.cryfwd_elig_dpnt_cd
570: from ben_elig_per_elctbl_chc epe,
571: ben_per_in_ler pil,
572: ben_pil_elctbl_chc_popl pel
573: where epe.auto_enrt_flag = 'Y'
574: --
575: -- Bug No: 4024312
576: -- bug 4730268 reverse the fix of 4024312

Line 614: ben_pil_elctbl_chc_popl pel

610: cursor c_elctbl_epe is
611: select null
612: from ben_elig_per_elctbl_chc epe,
613: ben_per_in_ler pil,
614: ben_pil_elctbl_chc_popl pel
615: where epe.elctbl_flag = 'Y'
616: --and pil.business_group_id = p_business_group_id
617: --and epe.business_group_id = pil.business_group_id
618: --and pel.business_group_id = epe.business_group_id

Line 642: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe

638: and pen.effective_end_date = hr_api.g_eot));
639: --
640: cursor c_pgm_enrt_dt(v_elig_per_elctbl_chc_id number,v_pgm_id number) is
641: select pel.enrt_perd_strt_dt
642: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe
643: where pel.pgm_id = v_pgm_id
644: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
645: and epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id;
646:

Line 651: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe

647: l_pgm_enrt_dt c_pgm_enrt_dt%rowtype;
648:
649: cursor c_pl_enrt_dt(v_elig_per_elctbl_chc_id number,v_pl_id number) is
650: select pel.enrt_perd_strt_dt
651: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe
652: where pel.pl_id = v_pl_id
653: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
654: and epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id;
655:

Line 1422: from ben_per_in_ler pil, ben_pil_elctbl_chc_popl pel

1418: l_person_id number;
1419: --
1420: cursor c_person_population is
1421: select distinct(pil.person_id) -- Bug 5529696
1422: from ben_per_in_ler pil, ben_pil_elctbl_chc_popl pel
1423: where
1424: pel.dflt_asnd_dt is null
1425: -- and pil.business_group_id = p_business_group_id
1426: and pel.dflt_asnd_dt is null

Line 1435: ben_pil_elctbl_chc_popl pel

1431: and pil.per_in_ler_id = pel.per_in_ler_id
1432: --and pel.business_group_id = pil.business_group_id
1433: and exists(select null
1434: from ben_elig_per_elctbl_chc epe,
1435: ben_pil_elctbl_chc_popl pel
1436: where epe.per_in_ler_id = pil.per_in_ler_id
1437: and epe.per_in_ler_id = pel.per_in_ler_id
1438: and pel.pil_elctbl_chc_popl_id =
1439: epe.pil_elctbl_chc_popl_id