APPS.PA_ADW_COLLECT_MAIN dependencies on PA_SRVC_TYPES_IT

Line 225: DELETE FROM PA_SRVC_TYPES_IT;

221: DELETE FROM PA_CLASS_CODES_IT;
222: DELETE FROM PA_LOWEST_RLMEM_IT;
223: DELETE FROM PA_TOP_RLMEM_IT;
224: DELETE FROM PA_RES_LISTS_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;

Line 373: purge_it_OADW('PA_SRVC_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
373: purge_it_OADW('PA_SRVC_TYPES_IT',earliest_collect_time);
374: purge_it_OADW('PA_ALL_SRVC_TYPES_IT',earliest_collect_time);
375: END IF;
376: /* Project Organization Dimension */
377: IF (dim_project_org = 'E') THEN

Line 455: DELETE FROM PA_SRVC_TYPES_IT

451:
452: DELETE FROM PA_RES_LISTS_IT
453: WHERE STATUS_CODE = 'T';
454:
455: DELETE FROM PA_SRVC_TYPES_IT
456: WHERE STATUS_CODE = 'T';
457:
458: DELETE FROM PA_PERIODS_IT
459: WHERE STATUS_CODE = 'T';