APPS.AP_PURGE_PKG dependencies on AP_CHECKS_ALL

Line 2165: FROM ap_checks_all AC,

2161: ac.check_id, ac.bank_account_id, ac.check_number, ac.check_date,
2162: ac.amount, ac.currency_code, DECODE(void_date, null, null, 'Y'),
2163: p_purge_name, ac.doc_sequence_id, ac.doc_sequence_value, ac.payment_id,
2164: ac.org_id
2165: FROM ap_checks_all AC,
2166: ap_invoice_payments_all IP,
2167: ap_purge_invoice_list PL
2168: WHERE PL.invoice_id = IP.invoice_id
2169: AND IP.check_id = AC.check_id

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

5040: END IF;
5041:
5042:
5043: -- delete_checks
5044: -- bug 5052764 - go to base table ap_checks_all to remove FTS
5045: DELETE FROM ap_checks_all C
5046: WHERE C.check_id IN (
5047: SELECT P.check_id
5048: FROM ap_invoice_payments P, ap_purge_invoice_list PL

Line 5045: DELETE FROM ap_checks_all C

5041:
5042:
5043: -- delete_checks
5044: -- bug 5052764 - go to base table ap_checks_all to remove FTS
5045: DELETE FROM ap_checks_all C
5046: WHERE C.check_id IN (
5047: SELECT P.check_id
5048: FROM ap_invoice_payments P, ap_purge_invoice_list PL
5049: WHERE P.invoice_id = PL.invoice_id