DBA Data[Home] [Help]

APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_ENRT_PERD

Line 1959: ben_enrt_perd enp

1955: and (p_person_id is null or pil.person_id = p_person_id)
1956: and (p_lf_evt_ocrd_dt is null
1957: or exists (select null
1958: from ben_pil_elctbl_chc_popl pel,
1959: ben_enrt_perd enp
1960: where pel.per_in_ler_id = pil.per_in_ler_id
1961: and pel.enrt_perd_id = enp.enrt_perd_id
1962: and enp.asnd_lf_evt_dt = l_lf_evt_ocrd_dt
1963: and pel.pil_elctbl_popl_stat_cd = 'STRTD' ))