displaying unwanted result

ALTER procedure [dbo].[proc_function_role_module] (@mid int, @rid int)
   as
   SELECT distinct sec_functions.functionname_vc 
       
   FROM [GCERP_SEC].[dbo].[sec_mrf_details] 

join sec_modules on sec_modules.modid_int = sec_mrf_details.modid_int
join sec_roles on sec_roles.roleid_int = sec_mrf_details.roleid_int
join sec_functions on sec_functions.fnid_int = sec_mrf_details.fnid_int
  
   where  sec_modules.modid_int = @mid and sec_roles.roleid_int= @rid