204: and did.expenditure_item_id = ei.expenditure_item_id
205: and di.draft_invoice_num = did.draft_invoice_num
206: and di.transfer_status_code = 'A'
207: and not exists ( select null
208: from ap_invoices_all ap
209: where ap.invoice_num = di.ra_invoice_number
210: )
211: )
212: );
394: and ppc.bill_another_project_flag = 'Y'
395: and ppc.receiver_task_id IS NOT NULL
396: and di.transfer_status_code ='A'
397: and not exists ( select null
398: from ap_invoices_all ap
399: where ap.invoice_num = di.ra_invoice_number
400: )
401: );
402: