APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on BEN_PL_F

Line 173: from ben_pl_f pl

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

Line 702: from ben_pl_f pl

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

Line 774: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%TYPE;

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