618: and apinv.invoice_type_lookup_code <> 'EXPENSE REPORT'
619: and exists (
620: (SELECT 1
621: FROM ap_invoice_payments_all invpay ,
622: pa_projects_all proj,
623: pa_implementations_all imp,
624: GL_PERIOD_STATUSES glp
625: WHERE proj.project_id = p_project_id
626: and invpay.invoice_id = appay.invoice_id