CREATE OR REPLACE FUNCTION public.fn_tutor_list_promotion_reasons(p_lang text DEFAULT 'es'::text)
 RETURNS TABLE(reason_id integer, label text, sort_order integer)
 LANGUAGE sql
 STABLE
AS $function$
    SELECT reason_id, label, sort_order
    FROM public.promotion_reasons
    WHERE active = true
      AND lang   = p_lang
    ORDER BY sort_order, reason_id;
$function$
;