--
-- acs_sc_impl__get_name/1
--
create or replace function acs_sc_impl__get_name(
  integer
) returns varchar as $$

declare
    p_impl_id			alias for $1;
    v_impl_name			varchar;
begin

    select impl_name into v_impl_name
    from acs_sc_impls
    where impl_id = p_impl_id;

    return v_impl_name;

end;$$ language plpgsql;