Annotation: office.get_cost_center_id_by_cost_center_code

CREATE OR REPLACE FUNCTION office.get_cost_center_id_by_cost_center_code(text)
RETURNS integer

Information: office.get_cost_center_id_by_cost_center_code

Schema	office
Function Name	get_cost_center_id_by_cost_center_code
Arguments	text
Owner	postgres
Result Type	integer
Description

Implementation: office.get_cost_center_id_by_cost_center_code

CREATE OR REPLACE FUNCTION office.get_cost_center_id_by_cost_center_code(text)
 RETURNS integer
 LANGUAGE plpgsql
 STABLE
AS $function$
BEGIN
    RETURN cost_center_id
    FROM office.cost_centers
    WHERE cost_center_code=$1;
END
$function$