APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on OIE_ADDON_MILEAGE_RATES

Line 1101: insert into oie_addon_mileage_rates_arc (

1097: ----------------------------------------------------------------------
1098: l_debug_info := 'Insert into Add On Mileage Rates.';
1099: ----------------------------------------------------------------------
1100:
1101: insert into oie_addon_mileage_rates_arc (
1102: ARC_REQ_ID,
1103: ARCHIVE_DATE,
1104: REPORT_LINE_ID,
1105: ADDON_RATE_TYPE,

Line 1126: from oie_addon_mileage_rates a, AP_EXP_REPORT_HEADERS_GT gt,

1122: A.LAST_UPDATED_BY,
1123: A.LAST_UPDATE_LOGIN,
1124: A.CREATED_BY,
1125: A.CREATION_DATE
1126: from oie_addon_mileage_rates a, AP_EXP_REPORT_HEADERS_GT gt,
1127: ap_expense_report_lines_all b
1128: where gt.report_header_id = b.report_header_id
1129: and a.report_line_id = b.report_line_id);
1130:

Line 1527: DELETE FROM oie_addon_mileage_rates

1523: ----------------------------------------------------------------------
1524: l_debug_info := 'Delete Add On Mileage rates.';
1525: ----------------------------------------------------------------------
1526:
1527: DELETE FROM oie_addon_mileage_rates
1528: WHERE report_line_id IN (
1529: SELECT report_line_id
1530: FROM oie_addon_mileage_rates_arc
1531: WHERE arc_req_id = p_request_id);

Line 1530: FROM oie_addon_mileage_rates_arc

1526:
1527: DELETE FROM oie_addon_mileage_rates
1528: WHERE report_line_id IN (
1529: SELECT report_line_id
1530: FROM oie_addon_mileage_rates_arc
1531: WHERE arc_req_id = p_request_id);
1532:
1533: fnd_file.put_line(fnd_file.log,'Purged ' || SQL%ROWCOUNT || ' Add On Mileage Rates');
1534: