[Home] [Help]
6738: (
6739: p_comp_lvl_fctr_id in number
6740: ) return varchar2 is
6741:
6742: l_comp_lvl_fctr_name ben_comp_lvl_fctr.name%type := null;
6743:
6744: cursor c_comp_lvl_fctr_name is
6745: select clf.name
6746: from ben_comp_lvl_fctr clf
6742: l_comp_lvl_fctr_name ben_comp_lvl_fctr.name%type := null;
6743:
6744: cursor c_comp_lvl_fctr_name is
6745: select clf.name
6746: from ben_comp_lvl_fctr clf
6747: where clf.comp_lvl_fctr_id = p_comp_lvl_fctr_id;
6748:
6749: begin
6750: open c_comp_lvl_fctr_name;