USP_PHONE_GETPHONESFORFORMAT

create procedure dbo.USP_PHONE_GETPHONESFORFORMAT
(
  @IDSETREGISTERID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier
)
as
begin
  declare @PROCESSID uniqueidentifier = 'fb4dc2b8-91d5-4cb7-b20e-bcb154225813';

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

  declare @SELECTION table
  (
    ID uniqueidentifier not null primary key
  );

  insert into @SELECTION (ID)
  select ID
  from dbo.UFN_CONSTITUENT_GETRECORDSINSELECTION_FORBUSINESSPROCESS(@CURRENTAPPUSERID, @IDSETREGISTERID, @PROCESSID, @BYPASSSECURITY, @BYPASSSITESECURITY);

  select
    PHONE.ID,
    PHONE.NUMBER,
    PHONE.COUNTRYID
  from @SELECTION SELECTION
  inner join dbo.PHONE on SELECTION.ID = PHONE.CONSTITUENTID;
end