228: DELETE FROM PA_BGT_TYPES_IT;
229: DELETE FROM PA_TSK_ACT_CMT_IT;
230: DELETE FROM PA_PRJ_ACT_CMT_IT;
231: DELETE FROM PA_TSK_BGT_LINES_IT;
232: DELETE FROM PA_PRJ_BGT_LINES_IT;
233: DELETE FROM PA_OLD_RES_ACCUM_DTLS;
234: DELETE FROM PA_OPER_UNITS_IT;
235: DELETE FROM PA_GL_PERIODS_IT;
236: DELETE FROM PA_FINANCIAL_QTRS_IT;
361: purge_it_OADW('PA_PRJ_ACT_CMT_IT_ALL',earliest_collect_time);
362: IF (collect_top_tasks_flag = 'Y' OR collect_lowest_tasks_flag = 'Y') THEN
363: purge_it_OADW('PA_TSK_BGT_LINES_IT_ALL',earliest_collect_time);
364: END IF;
365: purge_it_OADW('PA_PRJ_BGT_LINES_IT_ALL',earliest_collect_time);
366: /* Expenditure Type Dimension */
367: IF (dim_exp_type = 'E') THEN
368: purge_it_OADW('PA_EXP_TYPES_IT',earliest_collect_time);
369: purge_it_OADW('PA_ALL_EXP_TYPES_IT',earliest_collect_time);
472:
473: DELETE FROM PA_TSK_BGT_LINES_IT
474: WHERE STATUS_CODE = 'T';
475:
476: DELETE FROM PA_PRJ_BGT_LINES_IT
477: WHERE STATUS_CODE = 'T';
478:
479: DELETE FROM PA_OPER_UNITS_IT
480: WHERE STATUS_CODE = 'T';