DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on CE_STATEMENT_RECONCILS_ALL

Line 803: -- main SELECT query and base table CE_STATEMENT_RECONCILS_ALL for sub-query

799: END IF;
800:
801: -- Test Payments
802: -- Perf bug 5052674 -- go to base table AP_INVOICE_PAYMENTS_ALL for
803: -- main SELECT query and base table CE_STATEMENT_RECONCILS_ALL for sub-query
804: DELETE
805: FROM ap_purge_invoice_list PL
806: WHERE EXISTS
807: (SELECT 'payment not purgeable'

Line 851: from ce_statement_reconcils_all SR

847: > g_activity_date
848: ))
849: OR
850: EXISTS (SELECT 'Referenced by cashbook'
851: from ce_statement_reconcils_all SR
852: where C.check_id=SR.reference_id
853: AND SR.reference_type= 'PAYMENT'
854: AND SR.org_id = C.org_id )));
855: