How can we get the project foundation period close history for a particular ledger and period

Summary:

We need to get the history for a particular project foundation period and ledger. Is there any SQL query which we can use to get those details.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):