APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on AP_EXP_REPORT_DISTS_ARC

Line 658: insert into ap_exp_report_dists_arc (

654: ----------------------------------------------------------------------
655: l_debug_info := 'Insert into Dists.';
656: ----------------------------------------------------------------------
657:
658: insert into ap_exp_report_dists_arc (
659: ARC_REQ_ID,
660: ARCHIVE_DATE,
661: REPORT_HEADER_ID,
662: REPORT_LINE_ID,

Line 1569: FROM ap_exp_report_dists_arc

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);
1571:
1572: fnd_file.put_line(fnd_file.log,'Purged ' || SQL%ROWCOUNT || ' Dists');
1573: