7070: p_acty_base_rt_id in number
7071: ,p_effective_date in date
7072: ) return varchar2 is
7073:
7074: l_acty_base_rt_name ben_acty_base_rt_f.name%type := null;
7075:
7076: cursor c_acty_base_rt_name is
7077: select abr.name
7078: from ben_acty_base_rt_f abr
7074: l_acty_base_rt_name ben_acty_base_rt_f.name%type := null;
7075:
7076: cursor c_acty_base_rt_name is
7077: select abr.name
7078: from ben_acty_base_rt_f abr
7079: where abr.acty_base_rt_id = p_acty_base_rt_id
7080: and p_effective_date between abr.effective_start_date
7081: and abr.effective_end_date;
7082: