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