The p value for the Stouffer Z is simply that value that corresponds to the Stouffer Z sum. The real issue is that this p value is not necessarily a reliable guide to the confidence that might be placed in a result. Meta-analysis more art and intuition then it is science unless a series of studies were designed in advance for cumulative evaluation (or at least conducted under the same protocol).