CREATE OR REPLACE FUNCTION public.fn_admin_get_active_superadmin()
 RETURNS jsonb
 LANGUAGE sql
 STABLE
AS $function$
  SELECT jsonb_build_object('partner_id', p.partner_id, 'name', p.name, 'email', p.email)
  FROM public.superadmin_profiles sa
  JOIN public.partners p ON p.partner_id = sa.partner_id
  WHERE sa.status = 'ACTIVE'
  ORDER BY sa.partner_id
  LIMIT 1;
$function$
;