CREATE OR REPLACE FUNCTION public.fn_is_active_professor(p_partner_id bigint)
 RETURNS boolean
 LANGUAGE sql
 STABLE
AS $function$
  SELECT EXISTS (
    SELECT 1 FROM public.professor_profiles
    WHERE partner_id = p_partner_id AND status = 'ACTIVE'
  );
$function$
;