Annotation: core.get_account_id_by_party_id

CREATE OR REPLACE FUNCTION core.get_account_id_by_party_id(party_id bigint)
RETURNS bigint

Information: core.get_account_id_by_party_id

Schema	core
Function Name	get_account_id_by_party_id
Arguments	party_id bigint
Owner	postgres
Result Type	bigint
Description

Implementation: core.get_account_id_by_party_id

CREATE OR REPLACE FUNCTION core.get_account_id_by_party_id(party_id bigint)
 RETURNS bigint
 LANGUAGE plpgsql
 STABLE
AS $function$
BEGIN
    RETURN account_id
    FROM core.parties
    WHERE core.parties.party_id=$1;
END
$function$