USP_DATAFORMTEMPLATE_ADD_R68ONLINESUBMISSIONSETTINGSBYREFERENCENUMBER_PRELOAD

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_R68ONLINESUBMISSIONSETTINGSBYREFERENCENUMBER_PRELOAD
                    (
                        @CURRENTAPPUSERID uniqueidentifier,
                        @CCRNID uniqueidentifier = null output
                    )
                    as
                        set nocount on;                      

                        declare @DEFAULTSITEID uniqueidentifier
                        set @DEFAULTSITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)

                        if @DEFAULTSITEID is not null
                            set @CCRNID = dbo.UFN_CHARITYCLAIMREFERENCENUMBER_GETBYSITE(@DEFAULTSITEID)

                        return 0;