Can a high level office obtain a query/report that provides funding information for positions from other departments?

Yes. For example, Financial Aid will need this report for work study students. Departments will have to request this report from Budget, HR or Business Information Systems.