update vs4tpomb set tpobstatus=1 where (select tpodconfidential from vs4tpo where tpodno=tpobtpodno)=0
update vs4tprmb set tprmstatus=1 where (select tprdconfidential from vs4tpr where tprdno=tprmtprdno)=0
update vs4tsomb set tsobstatus=1 where (select tsodconfidential from vs4tso where tsodno=tsobtsodno)=0