How can I retrieve the full details of each exception?

Hi everyone,

I’m working on a report that returns schedule exceptions using the following query:

SELECT
1 KEY,
pse.SCHEDULE_EXCEPTION_ID,
pse.SCHEDULE_ID,
pse.SCHEDULE_ASSIGNMENT_ID,
pse.EXCEPTION_TYPE,
pse.EXCEPTION_ID,
pse.EXCEPTION_CODE,
pse.AVAILABILITY_CODE

FROM
PER_SCHEDULE_EXCEPTIONS pse

WHERE
pse.last_update_date BETWEEN NVL(:p_from_date, pse.last_update_date)
AND NVL(:p_to_date, pse.last_update_date)

And this is my output

My question is: how can I retrieve the full details of each exception?
For example, how can I identify which specific day is a public holiday ?