Need the Table/Field Mapping for Absence Plans and their Eligibility Profiles
SummaryNeed the Table/Field Mapping for Absence Plans and their Eligibility Profiles
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.