Determine the type of absence/leave in table of rejected leave

Hi,

I have a query for rejected leave for absence management:

select ntf.subject,ntf.responder as rejected_by,

ias.activity_status Status,

ias.activity_result_code Result,

ias.assigned_user assigned_user,

ias.notification_id NID,

ntf.status "Status"

from wf_item_activity_statuses ias,

wf_process_activities pa,

wf_activities ac,

wf_activities ap,

wf_items i,

wf_notifications ntf,

hr_api_transactions hat

where 1=1

and ias.notification_id is not null

and ias.activity_result_code='REJECTED'

and ias.item_type = 'HRSSA'

and ias.process_activity = pa.instance_id

and pa.activity_name = ac.name

and pa.activity_item_type = ac.item_type