Get Month from Period in iDempiere

 
-- select * from fnt_get_month_period(1000019);

create or replace function fnt_get_month_period(p_period_id numeric(10,0))
returns varchar
as $$
begin
    return
    (
        select
            upper(fnt_nombre_mes(extract(month from p.startdate)::int)) as num_mes
        from c_period p
        where p.c_period_id = p_period_id
    );
end;
$$ language plpgsql;