APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_ENRT_PERD

Line 1999: ben_enrt_perd enp

1995: and (p_person_id is null or pil.person_id = p_person_id)
1996: and (p_lf_evt_ocrd_dt is null
1997: or exists (select null
1998: from ben_pil_elctbl_chc_popl pel,
1999: ben_enrt_perd enp
2000: where pel.per_in_ler_id = pil.per_in_ler_id
2001: and pel.enrt_perd_id = enp.enrt_perd_id
2002: and enp.asnd_lf_evt_dt = l_lf_evt_ocrd_dt
2003: and pel.pil_elctbl_popl_stat_cd = 'STRTD' ))