Annotation: office.get_office_id_by_cash_repository_id

CREATE OR REPLACE FUNCTION office.get_office_id_by_cash_repository_id(integer)
RETURNS integer

Information: office.get_office_id_by_cash_repository_id

Schema	office
Function Name	get_office_id_by_cash_repository_id
Arguments	integer
Owner	postgres
Result Type	integer
Description

Implementation: office.get_office_id_by_cash_repository_id

CREATE OR REPLACE FUNCTION office.get_office_id_by_cash_repository_id(integer)
 RETURNS integer
 LANGUAGE plpgsql
AS $function$
BEGIN
        RETURN office_id
        FROM office.cash_repositories
        WHERE cash_repository_id=$1;
END
$function$