APPS.BEN_AUTOMATIC_ENROLLMENTS dependencies on BEN_PER_IN_LER

Line 47: from ben_per_in_ler pil

43:
44:
45: cursor c_prev_per_in_ler is
46: select max(pil.lf_evt_ocrd_dt)
47: from ben_per_in_ler pil
48: where pil.business_group_id = p_business_group_id
49: and pil.person_id = p_person_id
50: and pil.per_in_ler_id <> p_per_in_ler_id
51: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD');

Line 571: ben_per_in_ler pil,

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: --
575: -- Bug No: 4024312

Line 613: ben_per_in_ler pil,

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
617: --and epe.business_group_id = pil.business_group_id

Line 729: ben_per_in_ler pil,

725: cursor c_pgm_pnip_id(p_per_in_ler_id number) is
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

Line 745: ben_per_in_ler pil,

741: and epe.per_in_ler_id = pil.per_in_ler_id
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

Line 762: from ben_per_in_ler pil

758:
759: --
760: cursor c_lf_evt_ocrd_dt(p_per_in_ler_id number) is
761: select pil.lf_evt_ocrd_dt
762: from ben_per_in_ler pil
763: where pil.business_group_id = p_business_group_id
764: and pil.per_in_ler_id = p_per_in_ler_id
765: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD');
766: --

Line 767: ll_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type;

763: where pil.business_group_id = p_business_group_id
764: and pil.per_in_ler_id = p_per_in_ler_id
765: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD');
766: --
767: ll_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type;
768:
769: -- Bug 5529696
770: -- Local Variables
771: --

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