I don't think correlated query needs all the tables again as
a. outer query already filtering all ACT accounts and getting org_id
b Next task is for that org_id even if any one has (ACT/SUSP) status
then that org_id shouldn't appear
However, TS is least bothered for these replies as TS never turned back with these options. So its waste of time spending on this post henceforth and topic may be locked.