Annotation: core.get_salesperson_id_by_salesperson_code

CREATE OR REPLACE FUNCTION core.get_salesperson_id_by_salesperson_code(text)
RETURNS integer

Information: core.get_salesperson_id_by_salesperson_code

Schema	core
Function Name	get_salesperson_id_by_salesperson_code
Arguments	text
Owner	postgres
Result Type	integer
Description

Implementation: core.get_salesperson_id_by_salesperson_code

CREATE OR REPLACE FUNCTION core.get_salesperson_id_by_salesperson_code(text)
 RETURNS integer
 LANGUAGE plpgsql
 STABLE
AS $function$
BEGIN
    RETURN salesperson_id
    FROM core.salespersons
    WHERE salesperson_code=$1;
END
$function$