Annotation: core.get_fiscal_year_start_date

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

Information: core.get_fiscal_year_start_date

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

Implementation: core.get_fiscal_year_start_date

CREATE OR REPLACE FUNCTION core.get_fiscal_year_start_date(_office_id integer)
 RETURNS date
 LANGUAGE plpgsql
AS $function$
    DECLARE _date               date;
BEGIN

    SELECT starts_from 
    INTO _date
    FROM core.fiscal_year;

    RETURN _date;
END
$function$