CREATE OR REPLACE FUNCTION core.get_fiscal_year_end_date(_office_id integer)
RETURNS date
LANGUAGE plpgsql
AS $function$
BEGIN
RETURN MIN(value_date)
FROM core.frequency_setups
WHERE value_date >= transactions.get_value_date($1)
AND frequency_id > 4;
END
$function$