Looping in Bex Broadcast/ Multiple execution of Broadcast with diff selections

Hi Gurus,

We have a situation where we are Scheduling a broadcast using a control query,control query is based on employee manager position.
01.We are gettign the managers list from the control query.

02.Using the list we are broadcastign a billign query with employee as the char filter value. But we ned to send only the authorized manager data to each manager.

Can we apply authorizations or can we do a loop while scheduling th broadcasts.Please suggest.