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