APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on AP_CREDIT_CARD_TRXNS_ALL

Line 1048: from ap_credit_card_trxns_all a, AP_EXP_REPORT_HEADERS_GT gt

1044: DESCRIPTION,
1045: COMPANY_NUMBER,
1046: MARKET_CODE,
1047: VALIDATE_REQUEST_ID
1048: from ap_credit_card_trxns_all a, AP_EXP_REPORT_HEADERS_GT gt
1049: where gt.report_header_id = a.report_header_id);
1050:
1051: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' CC Transactions');
1052:

Line 1090: from ap_cc_trx_details a, ap_credit_card_trxns_all b, AP_EXP_REPORT_HEADERS_GT gt

1086: A.FOLIO_TYPE,
1087: A.ITEM_SEQ_NUMBER,
1088: A.ITEM_DESCRIPTION,
1089: A.TRANSACTION_DATE
1090: from ap_cc_trx_details a, ap_credit_card_trxns_all b, AP_EXP_REPORT_HEADERS_GT gt
1091: where gt.report_header_id = b.report_header_id
1092: and a.trx_id = b.trx_id);
1093:
1094: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' CC Transaction Details');

Line 1553: DELETE FROM ap_credit_card_trxns_all

1549: ----------------------------------------------------------------------
1550: l_debug_info := 'Delete CC Transactions.';
1551: ----------------------------------------------------------------------
1552:
1553: DELETE FROM ap_credit_card_trxns_all
1554: WHERE report_header_id IN (
1555: SELECT report_header_id
1556: FROM ap_credit_card_trxns_arc
1557: WHERE arc_req_id = p_request_id);