SQL to get Absence Enrollment details for Person

Summary:

SQL to get Absence Enrollment details for Person

Content (please ensure you mask any confidential information):

SQL to get Absence Enrollment details for Person

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

23C

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

SELECT

 peo.person_number AS PERSON_NUMBER,

 peo.person_id AS PERSON_ID,

 asg.WORK_TERMS_ASSIGNMENT_ID AS WORK_TERMS_ASSIGNMENT_ID,

 aapft.NAME AS ABSENCE_PLAN_NAME,

 acc_ent.end_bal AS BALANCE_AS_OF_TODAY,

 to_char(appe.enrt_st_dt,'MM/DD/YYYY') AS ENROLLMENT_START_DATE,

 to_char(appe.enrt_end_dt,'MM/DD/YYYY') AS CURRENT_ENROLLMENT_END_DATE