Annotation: transactions.get_default_currency_code_by_office_id

Information: transactions.get_default_currency_code_by_office_id

Implementation: transactions.get_default_currency_code_by_office_id

CREATE OR REPLACE FUNCTION transactions.get_default_currency_code_by_office_id(office_id integer)
 RETURNS character varying
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN
    (
        SELECT office.offices.currency_code 
        FROM office.offices
        WHERE office.offices.office_id = $1
        
    );
END
$function$