APPS.PA_ADW_COLLECT_MAIN dependencies on PA_PRJ_ACT_CMT_IT

Line 230: DELETE FROM PA_PRJ_ACT_CMT_IT;

226: DELETE FROM PA_PERIODS_IT;
227: DELETE FROM PA_ORGS_IT;
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;

Line 361: purge_it_OADW('PA_PRJ_ACT_CMT_IT_ALL',earliest_collect_time);

357: /* Fact Tables */
358: IF (collect_top_tasks_flag = 'Y' OR collect_lowest_tasks_flag = 'Y') THEN
359: purge_it_OADW('PA_TSK_ACT_CMT_IT_ALL',earliest_collect_time);
360: END IF;
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);

Line 470: DELETE FROM PA_PRJ_ACT_CMT_IT

466:
467: DELETE FROM PA_TSK_ACT_CMT_IT
468: WHERE STATUS_CODE = 'T';
469:
470: DELETE FROM PA_PRJ_ACT_CMT_IT
471: WHERE STATUS_CODE = 'T';
472:
473: DELETE FROM PA_TSK_BGT_LINES_IT
474: WHERE STATUS_CODE = 'T';