my @proc_requests = $schema->resultset('TblRequests')->search(
    {
        -or => [
            -or => [
                status => 'Offered',
                status => 'Denied',
                status => 'Cancelled',
                status => 'Conditional Offer',
            ],
            -and => [
                sent_email => { '!=', undef },
                sent_email => { '!=', '0000-00-00' },
            ],
        ],
    },
    { prefetch => 'p' }
);