736: and apinv.invoice_type_lookup_code <> 'EXPENSE REPORT'
737: and exists (
738: (SELECT 1
739: FROM ap_invoice_payments_all invpay ,
740: pa_projects_all proj,
741: pa_implementations_all imp,
742: GL_PERIOD_STATUSES glp
743: WHERE proj.project_id = p_project_id
744: and invpay.invoice_id = appay.invoice_id