AP Invoice statusses

Query to get an invoice's statusses.

select invoice_id,
       invoice_num,
       doc_sequence_value,
       validation_request_id,
       last_update_date,
       ap_invoices_pkg.get_approval_status(invoice_id,
                                           invoice_amount,
                                           payment_status_flag,
                                           invoice_type_lookup_code) apprv_stat,
       ap_invoices_pkg.get_posting_status(invoice_id) post
  from ap_invoices_all
where invoice_id = &1
/