APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on AP_POL_VIOLATIONS_ALL

Line 1367: from ap_pol_violations_all a, AP_EXP_REPORT_HEADERS_GT gt

1363: A.VIOLATION_DATE,
1364: A.DUP_REPORT_HEADER_ID,
1365: A.DUP_REPORT_LINE_ID,
1366: A.DUP_DIST_LINE_NUMBER
1367: from ap_pol_violations_all a, AP_EXP_REPORT_HEADERS_GT gt
1368: where gt.report_header_id = a.report_header_id);
1369:
1370: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Policy Violations');
1371:

Line 1462: DELETE FROM ap_pol_violations_all

1458: ----------------------------------------------------------------------
1459: l_debug_info := 'Delete Policy Violations.';
1460: ----------------------------------------------------------------------
1461:
1462: DELETE FROM ap_pol_violations_all
1463: WHERE report_header_id IN (
1464: SELECT report_header_id
1465: FROM ap_pol_violations_arc
1466: WHERE arc_req_id = p_request_id);