6716: (
6717: p_cmbn_age_los_fctr_id in number
6718: ) return varchar2 is
6719:
6720: l_cmbn_age_los_fctr_name ben_cmbn_age_los_fctr.name%type := null;
6721:
6722: cursor c_cmbn_age_los_fctr_name is
6723: select cla.name
6724: from ben_cmbn_age_los_fctr cla
6720: l_cmbn_age_los_fctr_name ben_cmbn_age_los_fctr.name%type := null;
6721:
6722: cursor c_cmbn_age_los_fctr_name is
6723: select cla.name
6724: from ben_cmbn_age_los_fctr cla
6725: where cla.cmbn_age_los_fctr_id = p_cmbn_age_los_fctr_id;
6726:
6727: begin
6728: open c_cmbn_age_los_fctr_name;