APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 648: from ap_expense_report_lines_all a, AP_EXP_REPORT_HEADERS_GT gt

644: UOM_DAYS,
645: IMAGE_RECEIPT_REQUIRED_FLAG,
646: RECEIPTS_ISSUE,
647: ADJUSTMENT_REASON_COPY
648: from ap_expense_report_lines_all a, AP_EXP_REPORT_HEADERS_GT gt
649: where gt.report_header_id = a.report_header_id);
650:
651: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Lines');
652:

Line 1127: ap_expense_report_lines_all b

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:
1131: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Add On Mileage Rates');

Line 1200: ap_expense_report_lines_all b

1196: A.CUST_ACCOMMODATION_AMOUNT,
1197: A.CUST_NIGHT_RATE_AMOUNT,
1198: A.CUST_PDM_RATE
1199: from oie_pdm_daily_breakups a, AP_EXP_REPORT_HEADERS_GT gt,
1200: ap_expense_report_lines_all b
1201: where gt.report_header_id = b.report_header_id
1202: and a.report_line_id = b.report_line_id);
1203:
1204: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Perdiem Daily Breakups');

Line 1237: ap_expense_report_lines_all b

1233: A.LAST_UPDATE_LOGIN,
1234: A.CREATED_BY,
1235: A.CREATION_DATE
1236: from oie_pdm_destinations a, AP_EXP_REPORT_HEADERS_GT gt,
1237: ap_expense_report_lines_all b
1238: where gt.report_header_id = b.report_header_id
1239: and a.report_line_id = b.report_line_id);
1240:
1241: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Perdiem Destinations');

Line 1286: ap_expense_report_lines_all b

1282: A.CREATION_DATE,
1283: A.CREATED_BY,
1284: A.LAST_UPDATE_LOGIN
1285: from oie_attendees_all a, AP_EXP_REPORT_HEADERS_GT gt,
1286: ap_expense_report_lines_all b
1287: where gt.report_header_id = b.report_header_id
1288: and a.report_line_id = b.report_line_id);
1289:
1290: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Attendees');

Line 1579: DELETE FROM ap_expense_report_lines_all

1575: ----------------------------------------------------------------------
1576: l_debug_info := 'Delete Lines.';
1577: ----------------------------------------------------------------------
1578:
1579: DELETE FROM ap_expense_report_lines_all
1580: WHERE report_line_id IN (
1581: SELECT report_line_id
1582: FROM ap_expense_report_lines_arc
1583: WHERE arc_req_id = p_request_id);