Modules are self contained; mods that do not extend the Main module are unable to use any goals from Main. If another module has code you want in your own mod, you can just copy/paste the code into your own module.

That being said, story goals have access to any procedure (and DBs) defined in any of the other goals within the same mod.