APPS.BEN_AUTOMATIC_ENROLLMENTS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 570: from ben_elig_per_elctbl_chc epe,

566: epe.business_group_id,
567: 'N' stage,
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: --

Line 612: from ben_elig_per_elctbl_chc epe,

608: --
609:
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

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 730: ben_elig_per_elctbl_chc epe

726: --
727: select distinct pen.pgm_id pgm_id, null pl_id
728: from ben_prtt_enrt_rslt_f pen,
729: ben_per_in_ler pil,
730: ben_elig_per_elctbl_chc epe
731: where pil.per_in_ler_id = p_per_in_ler_id
732: and pil.per_in_ler_Stat_cd = 'STRTD'
733: and pen.per_in_ler_id = pil.per_in_ler_id
734: and pen.business_group_id = p_business_group_id

Line 746: ben_elig_per_elctbl_chc epe

742: UNION
743: select distinct null pgm_id, pen.pl_id pl_id
744: from ben_prtt_enrt_rslt_f pen,
745: ben_per_in_ler pil,
746: ben_elig_per_elctbl_chc epe
747: where pil.per_in_ler_id = p_per_in_ler_id
748: and pil.per_in_ler_Stat_cd = 'STRTD'
749: and pen.per_in_ler_id = pil.per_in_ler_id
750: and pen.business_group_id = p_business_group_id

Line 1434: from ben_elig_per_elctbl_chc epe,

1430: and pil.per_in_ler_stat_cd = 'STRTD'
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 =