Annotation: core.get_quarter_end_date

CREATE OR REPLACE FUNCTION core.get_quarter_end_date(_office_id integer)
RETURNS date

Information: core.get_quarter_end_date

Schema	core
Function Name	get_quarter_end_date
Arguments	_office_id integer
Owner	postgres
Result Type	date
Description

Implementation: core.get_quarter_end_date

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