query get absence and time card details

Hi All,

I need a query to get these columns.

I have written code to get

SELECT PAPF.person_number,
To_char(HTPD.te_start_time, 'YYYY/MM/DD') AS ABSENCE_DATE,
HTPD.te_measure AS HOURS,
ABT.NAME AS ABSENCE_TYPE,
HTST.status_value AS STATUS,
ABE.per_absence_entry_id,
HTPD.tc_tm_rec_grp_id,
ABT.absence_type_id
--------------------Employee Details Tables----/
FROM per_all_people_f PAPF,
per_all_assignments_f PAAF,
per_periods_of_service PPS
----------------------------Timecard Tables----/
,
hwm_tm_rpt_entry_v HTPD,
hxt_tm_header HTH,
hwm_tm_statuses HTST,
hwm_tm_statuses HTS