query.sql

SELECT financing_applications.id
FROM financing_applications 
JOIN properties ON financing_applications.property_id = properties.id 
JOIN addresses ON properties.address_id = addresses.id 
WHERE addresses.county = 'Los Angeles' 
AND financing_applications.notice_to_proceed_sent_at IS NULL 
AND financing_applications.status != 'declined' 
AND financing_applications.status != 'withdrawn'
AND financing_applications.application_document_process_identifier IS NOT NULL;

    def rerun_pre_countersignature_recording_for_la!(params = {})
      rerun_processes!(params) { |app|
        app.within_la_county? && !app.notice_to_proceed_sent_at && !app.terminated?
      }
    end