Query to get Cancelled Requisitions in Oracle APPS

SELECT prh.requisition_header_id,

       (SELECT full_name 

           FROM per_all_people_f 

          WHERE person_id = prh.preparer_id

            AND SYSDATE BETWEEN effective_start_date AND effective_end_date) preparer,

       prh.segment1 requisition_num,

       TO_CHAR(TRUNC (prh.creation_date), 'DD-MON-RRRR') creation_date,

       prh.description,

       prh.note_to_authorizer

  FROM apps.po_requisition_headers_all prh

      ,apps.po_action_history pah

 WHERE action_code = 'CANCEL'

   AND pah.object_type_code = 'REQUISITION'

   AND pah.object_id = prh.requisition_header_id

   ORDER BY prh.creation_date