Annotation: core.get_recurring_amount_by_recurring_invoice_id

Information: core.get_recurring_amount_by_recurring_invoice_id

Implementation: core.get_recurring_amount_by_recurring_invoice_id

CREATE OR REPLACE FUNCTION core.get_recurring_amount_by_recurring_invoice_id(_recurring_invoice_id integer)
 RETURNS money_strict
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN
        recurring_amount
    FROM
        core.recurring_invoices
    WHERE
        core.recurring_invoices.recurring_invoice_id=$1;
END
$function$