Annotation: core.get_office_id_by_sales_tax_id

CREATE OR REPLACE FUNCTION core.get_office_id_by_sales_tax_id(_sales_tax_id integer)
RETURNS integer

Information: core.get_office_id_by_sales_tax_id

Schema	core
Function Name	get_office_id_by_sales_tax_id
Arguments	_sales_tax_id integer
Owner	postgres
Result Type	integer
Description

Implementation: core.get_office_id_by_sales_tax_id

CREATE OR REPLACE FUNCTION core.get_office_id_by_sales_tax_id(_sales_tax_id integer)
 RETURNS integer
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN office_id
    FROM core.sales_taxes
    WHERE core.sales_taxes.sales_tax_id=$1;
END
$function$