trigger BIIB_GenerateSOB_Autoclosure on Attachment (after insert) {

String wi_Item='Generate SOB';
String sr_type='Benefit Investigation';
Set<Id> attachIds = new Set<Id>();
List<Attachment> sr_attachment = new List<Attachment>();
List<BIIB_Work__c> updateSOB_WI = new List<BIIB_Work__c>();

    for(Attachment atc: Trigger.new){
        if(atc.ParentId.getSobjectType() == Case.SobjectType)
            attachIds.add(atc.ParentId);
    }

List<BIIB_Work__c> sobWI = [select id,Name,BIIB_Case__r.Id,BIIB_Case__r.BIIB_SR_Type__c from BIIB_Work__c where BIIB_Case__r.Id IN :attachIds and Name=:wi_Item and BIIB_Case__r.BIIB_SR_Type__c =:sr_type limit 49999];
    if(sobWI.size()>0)
    {
        sr_attachment = [select id from Attachment where ParentId=: sobWI[0].BIIB_Case__r.Id];
    }
    if(!sr_attachment.isEmpty()){
        for (BIIB_Work__c work: sobWI){
             work.BIIB_Result__c = 'BI Complete' ;
             work.BIIB_Status__c = 'Closed' ;
             updateSOB_WI.add(work);
        }
      }
    if(!updateSOB_WI.isEmpty())
        Database.update(updateSOB_WI, false);

}