Annotation: core.get_currency_code_by_office_id

CREATE OR REPLACE FUNCTION core.get_currency_code_by_office_id(office_id integer)
RETURNS text

Information: core.get_currency_code_by_office_id

Schema	core
Function Name	get_currency_code_by_office_id
Arguments	office_id integer
Owner	postgres
Result Type	text
Description

Implementation: core.get_currency_code_by_office_id

CREATE OR REPLACE FUNCTION core.get_currency_code_by_office_id(office_id integer)
 RETURNS text
 LANGUAGE plpgsql
 STABLE
AS $function$
BEGIN
    RETURN office.offices.currency_code
    FROM office.offices
    WHERE office.offices.office_id=$1;
END
$function$