Annotation: transactions.is_eod_initialized

Information: transactions.is_eod_initialized

Implementation: transactions.is_eod_initialized

CREATE OR REPLACE FUNCTION transactions.is_eod_initialized(_office_id integer, _value_date date)
 RETURNS boolean
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF EXISTS
    (
        SELECT * FROM transactions.day_operation
        WHERE office_id = _office_id
        AND value_date = _value_date
        AND completed = false
    ) then
        RETURN true;
    END IF;

    RETURN false;
END
$function$