DBA Data[Home] [Help]

APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on OIE_ATTENDEES_ARC

Line 1248: insert into oie_attendees_arc (

1244: ----------------------------------------------------------------------
1245: l_debug_info := 'Insert into OIE Attendees.';
1246: ----------------------------------------------------------------------
1247:
1248: insert into oie_attendees_arc (
1249: ARC_REQ_ID,
1250: ARCHIVE_DATE,
1251: ATTENDEE_LINE_ID,
1252: REPORT_LINE_ID,

Line 1491: FROM oie_attendees_arc

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);
1493:
1494: fnd_file.put_line(fnd_file.log,'Purged ' || SQL%ROWCOUNT || ' Attendees');
1495: