CREATE OR REPLACE FUNCTION core.get_fiscal_half_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 > 3;
END
$function$