DBA Data[Home] [Help]

APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on OIE_PDM_DAILY_BREAKUPS_ARC

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 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: