6522: p_per_info_chg_cs_ler_id in number
6523: ,p_effective_date in date
6524: ) return varchar2 is
6525:
6526: l_per_info_chg_cs_ler_name ben_per_info_chg_cs_ler_f.name%type := null;
6527:
6528: cursor c_per_info_chg_cs_ler_name is
6529: select psl.name
6530: from ben_per_info_chg_cs_ler_f psl
6526: l_per_info_chg_cs_ler_name ben_per_info_chg_cs_ler_f.name%type := null;
6527:
6528: cursor c_per_info_chg_cs_ler_name is
6529: select psl.name
6530: from ben_per_info_chg_cs_ler_f psl
6531: where psl.per_info_chg_cs_ler_id = p_per_info_chg_cs_ler_id
6532: and p_effective_date between psl.effective_start_date
6533: and psl.effective_end_date;
6534: