USP_ADDRESS_INVALIDATECOORDINATES

            create procedure dbo.USP_ADDRESS_INVALIDATECOORDINATES(
                @ADDRESSID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            ) as
                set nocount on;

                declare @ID uniqueidentifier;
                select
                    @ID = AC.ID
                from
                    dbo.ADDRESSCOORDINATES AC
                where
                    AC.ADDRESSID = @ADDRESSID;

                if @ID is not null begin
                    exec dbo.USP_ADDRESSCOORDINATES_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
                end

                return 0;