APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on OIE_PDM_DESTINATIONS

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 1236: from oie_pdm_destinations a, AP_EXP_REPORT_HEADERS_GT gt,

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

Line 1501: DELETE FROM oie_pdm_destinations

1497: ----------------------------------------------------------------------
1498: l_debug_info := 'Delete Perdiem destinations.';
1499: ----------------------------------------------------------------------
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);

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: