APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on BEN_PL_F

Line 170: from ben_pl_f pl

166: pl.dpnt_cvg_strt_dt_cd,
167: pl.dpnt_cvg_strt_dt_rl,
168: pl.dpnt_cvg_end_dt_cd,
169: pl.dpnt_cvg_end_dt_rl
170: from ben_pl_f pl
171: where pl.pl_id = l_pl_id
172: and pl.business_group_id = l_business_group_id
173: and nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)
174: between nvl(pl.effective_start_date,p_effective_date)

Line 699: from ben_pl_f pl

695: select pl.pl_id,
696: pl.vrfy_fmly_mmbr_cd,
697: pl.vrfy_fmly_mmbr_rl,
698: pl.per_cvrd_cd
699: from ben_pl_f pl
700: where pl.business_group_id = p_business_group_id
701: and pl.pl_stat_cd = 'A'
702: and pl.pl_id = l_pl_id
703: and p_effective_date

Line 771: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%TYPE;

767: --
768: l_elig_to_prte_rsn_id ben_elig_to_prte_rsn_f.elig_to_prte_rsn_id%TYPE;
769: l_vrfy_fmly_mmbr_cd ben_pgm_f.vrfy_fmly_mmbr_cd%TYPE;
770: l_vrfy_fmly_mmbr_rl ben_pgm_f.vrfy_fmly_mmbr_rl%TYPE;
771: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%TYPE;
772: l_found boolean := false;
773: --
774: begin
775: --