USP_BBNC_GETSELECTIONLISTINFO

            create procedure [dbo].[USP_BBNC_GETSELECTIONLISTINFO](@LISTID int)
            with execute as caller
            as

            begin
                set nocount on;

                select 
                    DBOBJECTNAME,
                    OBJECTTYPE 
                from 
                    dbo.IDSETREGISTER
                inner join 
                    dbo.BBNCIDSETIDMAP on IDSETREGISTER.ID = BBNCIDSETIDMAP.IDSETREGISTERID
                where
                    BBNCIDSETIDMAP.ID = @LISTID
            end