Annotation: core.get_state_id_by_shipping_address_code

CREATE OR REPLACE FUNCTION core.get_state_id_by_shipping_address_code(text, bigint)
RETURNS integer

Information: core.get_state_id_by_shipping_address_code

Schema	core
Function Name	get_state_id_by_shipping_address_code
Arguments	text, bigint
Owner	postgres
Result Type	integer
Description

Implementation: core.get_state_id_by_shipping_address_code

CREATE OR REPLACE FUNCTION core.get_state_id_by_shipping_address_code(text, bigint)
 RETURNS integer
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN
    (
        SELECT
            state_id
        FROM
            core.shipping_addresses
        WHERE 
            core.shipping_addresses.shipping_address_code=$1
        AND
            core.shipping_addresses.party_id=$2
    );
END
$function$