UFN_GENDERCODEDEFAULTMAPPING_GETGENDERCODEID

            create function dbo.UFN_GENDERCODEDEFAULTMAPPING_GETGENDERCODEID(@DEFAULTREASONCODE tinyint)
            returns uniqueidentifier
                with execute as caller
                as 
                begin
                    declare @GENDERCODEID uniqueidentifier

                    select @GENDERCODEID = GENDERCODEDEFAULTMAPPING.GENDERCODEID 
                    from dbo.GENDERCODEDEFAULTMAPPING
                    where 
                    GENDERCODEDEFAULTMAPPING.DEFAULTREASONCODE = @DEFAULTREASONCODE

                return @GENDERCODEID;

            end