APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on OIE_PDM_DESTINATIONS_ARC

Line 1211: insert into oie_pdm_destinations_arc (

1207: ----------------------------------------------------------------------
1208: l_debug_info := 'Insert into Perdiem Destinations.';
1209: ----------------------------------------------------------------------
1210:
1211: insert into oie_pdm_destinations_arc (
1212: ARC_REQ_ID,
1213: ARCHIVE_DATE,
1214: PDM_DESTINATION_ID,
1215: REPORT_LINE_ID,

Line 1504: FROM oie_pdm_destinations_arc

1500:
1501: DELETE FROM oie_pdm_destinations
1502: WHERE pdm_destination_id IN (
1503: SELECT pdm_destination_id
1504: FROM oie_pdm_destinations_arc
1505: WHERE arc_req_id = p_request_id);
1506:
1507: fnd_file.put_line(fnd_file.log,'Purged ' || SQL%ROWCOUNT || ' Perdiem Destinations');
1508: