need a query to get all the expense reports that are waiting for approval.

Hi,
I need a query that should give me the expense reports and its count which are unapproved. This below query brings all the expenses that are submitted and also which are been rejected. How can I avoid picking up rejected expense reports.

Thanks
RG


select distinct p.email_address,
       a.invoice_num,  
       a.created_by,          
        -- count(*) cnt,
                vd.name
from ap_expense_report_headers_all  a,
     per_all_people_f                  p,
     wf_item_activity_statuses       wias,
     v$database                        vd
where p.PERSON_ID = a.expense_current_approver_id
and a.set_of_books_id = '1'
and a.expense_status_code like 'PENDMGR%'