APPS.BEN_PROC_COMMON_ENRT_RSLT dependencies on BEN_ENRT_PERD

Line 869: l_asnd_lf_evt_dt ben_enrt_perd.asnd_lf_evt_dt%TYPE;

865: ,p_validate in boolean default false) is
866: --
867: -- Declare cursors and local variables
868: --
869: l_asnd_lf_evt_dt ben_enrt_perd.asnd_lf_evt_dt%TYPE;
870: -- l_ler_id ben_per_in_ler.ler_id%TYPE;
871: l_exists varchar2(1);
872: l_proc varchar2(72) := g_package||'process_post_enrollment';
873: --

Line 880: ben_enrt_perd enp

876: --
877: cursor c_pil_elctbl_chc_popl is
878: select enp.asnd_lf_evt_dt
879: from ben_pil_elctbl_chc_popl pel,
880: ben_enrt_perd enp
881: where pel.per_in_ler_id = p_per_in_ler_id
882: and nvl(pel.pgm_id,-1) = nvl(p_pgm_id,-1)
883: and nvl(pel.pl_id,-1) = nvl(p_pl_id,-1)
884: and pel.enrt_perd_id = enp.enrt_perd_id;