APPS.AP_PURGE_PKG dependencies on AP_CHECKS_ALL

Line 2420: FROM ap_checks_all AC,

2416: ac.check_id, ac.bank_account_id, ac.check_number, ac.check_date,
2417: ac.amount, ac.currency_code, DECODE(void_date, null, null, 'Y'),
2418: p_purge_name, ac.doc_sequence_id, ac.doc_sequence_value, ac.payment_id,
2419: ac.org_id
2420: FROM ap_checks_all AC,
2421: ap_invoice_payments_all IP,
2422: ap_purge_invoice_list PL
2423: WHERE PL.invoice_id = IP.invoice_id
2424: AND IP.check_id = AC.check_id

Line 5552: -- bug 5052764 - go to base table ap_checks_all to remove FTS

5548: END IF;
5549:
5550:
5551: -- delete_checks
5552: -- bug 5052764 - go to base table ap_checks_all to remove FTS
5553: DELETE FROM ap_checks_all C
5554: WHERE C.check_id IN (
5555: SELECT P.check_id
5556: FROM ap_invoice_payments P, ap_purge_invoice_list PL

Line 5553: DELETE FROM ap_checks_all C

5549:
5550:
5551: -- delete_checks
5552: -- bug 5052764 - go to base table ap_checks_all to remove FTS
5553: DELETE FROM ap_checks_all C
5554: WHERE C.check_id IN (
5555: SELECT P.check_id
5556: FROM ap_invoice_payments P, ap_purge_invoice_list PL
5557: WHERE P.invoice_id = PL.invoice_id