How to check if an employee is eligible for an eligibility profile using pl/sql
Is there a pl/sql function where I can pass a person_id and a eligibility profile id and the function returns if the employee is eligible based on that eligibility profile.
I am using eligibility profile in my Performance Management Plan. Without republishing the plan, I would like to check if an employee will be part of the plan, if the plan is republished.
There is a script TM_Diagnostics.sql, But it does not consider eligibility profile if eligibility profile is used in the Performance Management Plan.
When the PMP is republished, it includes employees are are not currently part of the plan but are eligible. There must be some pl/sql code which checks the eligibility of the person.