0
0
select per.person_number,PER_ABSENCE_ENTRY_ID ,abs.absence_type_id,
abs.name absence_type, to_char(apae.start_date,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') start_date, to_char(apae.end_date,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') end_date, duration from ANC_PER_ABS_ENTRIES apae, PER_PERIODS_OF_SERVICE pps, PER_ALL_PEOPLE_F per, ANC_ABSENCE_TYPES_VL abs where apae.period_of_service_id = pps.period_of_Service_id and apae.absence_type_id = abs.absence_type_id and pps.person_id = per.person_id and trunc(sysdate) between abs.effective_start_date and abs.effective_end_Date and trunc(sysdate) between per.effective_start_date and per.effective_end_Date and per.person_number = '11111111' order by per.person_number
I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.