USP_ADDRESS_GETLIST

            CREATE procedure dbo.USP_ADDRESS_GETLIST(
                @ONLYPRIMARY bit = null,
                @CURRENTAPPUSERID uniqueidentifier = null
            ) as
                set nocount on;

                declare @BPID uniqueidentifier = '3269A1D1-31CB-4D28-945C-B7623A3EFCCA';

                declare @BYPASSSECURITY bit;
                declare @BYPASSSITESECURITY bit;                
                exec dbo.USP_SECURITY_APPUSER_BYPASSSECURITYFORBUSINESSPROCESS @CURRENTAPPUSERID, @BPID, @BYPASSSECURITY output, @BYPASSSITESECURITY output;                

                select ADDRESS.ID, 
                    ADDRESS.ADDRESSBLOCK,
                    ADDRESS.CITY,
                    coalesce(STATE.ABBREVIATION, '') [STATE],
                    ADDRESS.POSTCODE,
                    coalesce(COUNTRY.ABBREVIATION, '') [COUNTRY]
                from dbo.ADDRESS
                    inner join dbo.UFN_CONSTITUENT_GETRECORDSINSELECTION_FORBUSINESSPROCESS(@CURRENTAPPUSERID, null, @BPID, @BYPASSSECURITY, @BYPASSSITESECURITY) CONSTITUENT on ADDRESS.CONSTITUENTID = CONSTITUENT.ID
                    left join dbo.STATE on STATE.ID = ADDRESS.STATEID
                    left join dbo.COUNTRY on COUNTRY.ID = ADDRESS.COUNTRYID

                /*#IDSETEXTENSION*/

                where (@ONLYPRIMARY is null or @ONLYPRIMARY = 0) or ADDRESS.ISPRIMARY = 1
                order by ADDRESS.DATEADDED;