Forum OpenACS Q&A: Re: How to get all package_id's of classes/communities and subgroups?

I found a table dotlrn_community_applets which is maintaining a mapping of  packages per commmunity:
check dotlrn/sql/oracle/applets-create.sql. May be that can help...

regards
Harish