APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on AP_EXP_REPORT_DISTS_ALL

Line 767: from ap_exp_report_dists_all a, AP_EXP_REPORT_HEADERS_GT gt

763: RECEIPT_CURRENCY_CODE,
764: RECEIPT_CONVERSION_RATE,
765: RECEIPT_CURRENCY_AMOUNT,
766: WEB_PARAMETER_ID
767: from ap_exp_report_dists_all a, AP_EXP_REPORT_HEADERS_GT gt
768: where gt.report_header_id = a.report_header_id);
769:
770: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Dists');
771:

Line 1566: DELETE FROM ap_exp_report_dists_all

1562: ----------------------------------------------------------------------
1563: l_debug_info := 'Delete Distributions.';
1564: ----------------------------------------------------------------------
1565:
1566: DELETE FROM ap_exp_report_dists_all
1567: WHERE report_distribution_id IN (
1568: SELECT report_distribution_id
1569: FROM ap_exp_report_dists_arc
1570: WHERE arc_req_id = p_request_id);