32: SELECT 'VENDOR INVOICE PENDING'
33: FROM dual
34: WHERE EXISTS ( SELECT aid.invoice_id
35: FROM ap_invoice_distributions_all aid,
36: ap_invoices_all ai
37: WHERE aid.project_id = p_project_id
38: AND aid.invoice_id = ai.invoice_id
39: AND ai.invoice_type_lookup_code <> 'EXPENSE REPORT'
40: AND (p_active_flag = 'C' or
181: UNION /* Added for bug 2553822 */
182: /* Bug 2598071 SELECT aid.invoice_id */
183: SELECT aid.invoice_id
184: FROM ap_invoice_distributions_all aid,
185: ap_invoices_all ai
186: WHERE aid.project_id = p_project_id
187: AND aid.invoice_id = ai.invoice_id
188: AND ai.source <> 'Oracle Project Accounting'
189: AND ai.invoice_type_lookup_code = 'EXPENSE REPORT'