Need the Table/Field Mapping for Absence Plans and their Eligibility Profiles

Summary

Need the Table/Field Mapping for Absence Plans and their Eligibility Profiles

Content

Hi i am trying to put a script that extracts the setup of Absence Plans. I could not find the right join between Absence Plans table and Eligibility profiles to pull the Eligibility Profile for each Absence Plan.

Here is the sql which i am working on. If you run this sql this will not return any data. Once you comment this join

--AND BELP.ELIGY_PRFL_ID = ANCP.BEN_ELIG_PROFILE_ID

from the following query it will give the result but not right.

Please help me with this.