It has been asked of me to run some custom queries and build reports for each package(OE, AP, AR, PR, ect.) using their corresponding Periods(Period Start and End Dates). The problem I am running into is I can't seem to find the table where the packages are stored with their package_codes(AP, OE, AR) and their Period_Ids. I have found where the Periods are stored. They can be found in syprdfil_sql. Each entry has a unique prd_key. I know this is where the periods are stored because inside Progression Explorer >> System Manager >> Maintain >> System Periods >> I was able to make changes to each of them, one at a time, and determine which prd_key goes to what package. At the same time verified there was one row in syprdfil_sql for each package displayed in the drop-down boxes(AP, AR, OE, PR, ect).
Where are the table(s) that hold this information for the different packages? I have attached a couple of screenshots to help everyone understand what I'm asking for.
Many thanks for any help!