APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on OIE_ATTENDEES_ALL

Line 1285: from oie_attendees_all a, AP_EXP_REPORT_HEADERS_GT gt,

1281: A.LAST_UPDATED_BY,
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:

Line 1488: DELETE FROM oie_attendees_all

1484: ----------------------------------------------------------------------
1485: l_debug_info := 'Delete Attendee information.';
1486: ----------------------------------------------------------------------
1487:
1488: DELETE FROM oie_attendees_all
1489: WHERE attendee_line_id IN (
1490: SELECT attendee_line_id
1491: FROM oie_attendees_arc
1492: WHERE arc_req_id = p_request_id);