APPS.PA_ADW_COLLECT_MAIN dependencies on PA_EXP_TYPES_IT

Line 218: DELETE FROM PA_EXP_TYPES_IT;

214:
215: DELETE FROM PA_TOP_TASKS_IT;
216: DELETE FROM PA_PROJECTS_IT;
217: DELETE FROM PA_PRJ_TYPES_IT;
218: DELETE FROM PA_EXP_TYPES_IT;
219: DELETE FROM PA_PRJ_CLASSES_IT;
220: DELETE FROM PA_CLASS_CATGS_IT;
221: DELETE FROM PA_CLASS_CODES_IT;
222: DELETE FROM PA_LOWEST_RLMEM_IT;

Line 368: purge_it_OADW('PA_EXP_TYPES_IT',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);
370: END IF;
371: /* Service Type Dimension */
372: IF (dim_srvc_type = 'E') THEN

Line 434: DELETE FROM PA_EXP_TYPES_IT

430:
431: DELETE FROM PA_PRJ_TYPES_IT
432: WHERE STATUS_CODE = 'T';
433:
434: DELETE FROM PA_EXP_TYPES_IT
435: WHERE STATUS_CODE = 'T';
436:
437: DELETE FROM PA_PRJ_CLASSES_IT
438: WHERE STATUS_CODE = 'T';