APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on AP_POL_VIOLATIONS_ARC

Line 1328: insert into ap_pol_violations_arc (

1324: ----------------------------------------------------------------------
1325: l_debug_info := 'Insert into Violations.';
1326: ----------------------------------------------------------------------
1327:
1328: insert into ap_pol_violations_arc (
1329: ARC_REQ_ID,
1330: ARCHIVE_DATE,
1331: REPORT_HEADER_ID,
1332: DISTRIBUTION_LINE_NUMBER,

Line 1465: FROM ap_pol_violations_arc

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);
1467:
1468: fnd_file.put_line(fnd_file.log,'Purged ' || SQL%ROWCOUNT || ' Policy Violations');
1469: