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