APPS.BEN_PROC_COMMON_ENRT_RSLT dependencies on BEN_ENRT_PERD

Line 886: l_asnd_lf_evt_dt ben_enrt_perd.asnd_lf_evt_dt%TYPE;

882: ,p_validate in boolean default false) is
883: --
884: -- Declare cursors and local variables
885: --
886: l_asnd_lf_evt_dt ben_enrt_perd.asnd_lf_evt_dt%TYPE;
887: -- l_ler_id ben_per_in_ler.ler_id%TYPE;
888: l_exists varchar2(1);
889: l_proc varchar2(72) := g_package||'process_post_enrollment';
890: --

Line 897: ben_enrt_perd enp

893: --
894: cursor c_pil_elctbl_chc_popl is
895: select enp.asnd_lf_evt_dt
896: from ben_pil_elctbl_chc_popl pel,
897: ben_enrt_perd enp
898: where pel.per_in_ler_id = p_per_in_ler_id
899: and nvl(pel.pgm_id,-1) = nvl(p_pgm_id,-1)
900: and nvl(pel.pl_id,-1) = nvl(p_pl_id,-1)
901: and pel.enrt_perd_id = enp.enrt_perd_id;