DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_ICIP dependencies on AP_INVOICES_ALL

Line 208: from ap_invoices_all ap

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: );

Line 398: from ap_invoices_all ap

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: