APPS.PA_ADW_COLLECT_MAIN dependencies on PA_TSK_ACT_CMT_IT

Line 229: DELETE FROM PA_TSK_ACT_CMT_IT;

225: DELETE FROM PA_SRVC_TYPES_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;

Line 359: purge_it_OADW('PA_TSK_ACT_CMT_IT_ALL',earliest_collect_time);

355: purge_it_OADW('PA_FINANCIAL_YRS_IT',earliest_collect_time);
356: purge_it_OADW('PA_ALL_FINANCIAL_YRS_IT',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);

Line 467: DELETE FROM PA_TSK_ACT_CMT_IT

463:
464: DELETE FROM PA_BGT_TYPES_IT
465: WHERE STATUS_CODE = 'T';
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';