So when ever the users manager changes i need to update all the opportunities that are associated with that user how do i accomplish this. I used process builder but it is not updating the records

I have a Date field called Term Date, so when it is blank i need to show as Active on VF page or else Inactive, i am not sure how to get an approach on this. 

Thank you 

 Set<Id> OTCorpids = new Set<Id>();
        for(Order_Transaction__c OTlist : ots){
            OTCorpids.add(OTlist.Corp_Account__c);
            system.debug('OTCorpids***** '+OTCorpids);
        }
        
        Map<Id, List<Account>> corptogrpacctsmap = new Map<Id,List<Account>>();
        for(Account grpacct : [SELECT Id,Parentid,RecordTypeId FROM Account WHERE Parentid IN: OTCorpids AND Status__c = 'Active' order by recordtypeId]){// this is the line i am getting the error. 

I am not sure why

Thanks 

So when ever the users manager changes i need to update all the opportunities that are associated with that user how do i accomplish this. I used process builder but it is not updating the records