APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on OIE_PDM_DAILY_BREAKUPS

Line 1138: insert into oie_pdm_daily_breakups_arc (

1134: ----------------------------------------------------------------------
1135: l_debug_info := 'Insert into Perdiem Daily Breakups.';
1136: ----------------------------------------------------------------------
1137:
1138: insert into oie_pdm_daily_breakups_arc (
1139: ARC_REQ_ID,
1140: ARCHIVE_DATE,
1141: PDM_DAILY_BREAKUP_ID,
1142: REPORT_LINE_ID,

Line 1199: from oie_pdm_daily_breakups a, AP_EXP_REPORT_HEADERS_GT gt,

1195: A.CUST_MEALS_AMOUNT,
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:

Line 1514: DELETE FROM oie_pdm_daily_breakups

1510: ----------------------------------------------------------------------
1511: l_debug_info := 'Delete Perdiem Daily Beakups.';
1512: ----------------------------------------------------------------------
1513:
1514: DELETE FROM oie_pdm_daily_breakups
1515: WHERE pdm_daily_breakup_id IN (
1516: SELECT pdm_daily_breakup_id
1517: FROM oie_pdm_daily_breakups_arc
1518: WHERE arc_req_id = p_request_id);

Line 1517: FROM oie_pdm_daily_breakups_arc

1513:
1514: DELETE FROM oie_pdm_daily_breakups
1515: WHERE pdm_daily_breakup_id IN (
1516: SELECT pdm_daily_breakup_id
1517: FROM oie_pdm_daily_breakups_arc
1518: WHERE arc_req_id = p_request_id);
1519:
1520: fnd_file.put_line(fnd_file.log,'Purged ' || SQL%ROWCOUNT || ' Perdiem Daily Breakups');
1521: