7231: p_dpnt_cvg_eligy_prfl_id in number
7232: ,p_effective_date in date
7233: ) return varchar2 is
7234:
7235: l_dpnt_cvg_eligy_prfl_name ben_dpnt_cvg_eligy_prfl_f.name%type := null;
7236:
7237: cursor c_dpnt_cvg_eligy_prfl_name is
7238: select dce.name
7239: from ben_dpnt_cvg_eligy_prfl_f dce
7235: l_dpnt_cvg_eligy_prfl_name ben_dpnt_cvg_eligy_prfl_f.name%type := null;
7236:
7237: cursor c_dpnt_cvg_eligy_prfl_name is
7238: select dce.name
7239: from ben_dpnt_cvg_eligy_prfl_f dce
7240: where dce.dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
7241: and p_effective_date between dce.effective_start_date
7242: and dce.effective_end_date;
7243: