APPS.PA_ADW_COLLECT_MAIN dependencies on PA_ALL_PRJ_TYPES_IT

Line 241: DELETE FROM PA_ALL_PRJ_TYPES_IT;

237: DELETE FROM PA_FINANCIAL_YRS_IT;
238: DELETE FROM PA_ALL_FINANCIAL_YRS_IT;
239: DELETE FROM PA_ALL_EXP_TYPES_IT;
240: DELETE FROM PA_ALL_SRVC_TYPES_IT;
241: DELETE FROM PA_ALL_PRJ_TYPES_IT;
242: DELETE FROM PA_PRJ_ORGS_IT;
243: DELETE FROM PA_PRJ_BUSINESS_GRPS_IT;
244: DELETE FROM PA_EXP_ORGS_IT;
245: DELETE FROM PA_EXP_BUSINESS_GRPS_IT;

Line 344: purge_it_OADW('PA_ALL_PRJ_TYPES_IT',earliest_collect_time);

340: purge_it_OADW('PA_LOWEST_TASKS_IT',earliest_collect_time);
341: END IF;
342: purge_it_OADW('PA_PROJECTS_IT_ALL',earliest_collect_time);
343: purge_it_OADW('PA_PRJ_TYPES_IT_ALL',earliest_collect_time);
344: purge_it_OADW('PA_ALL_PRJ_TYPES_IT',earliest_collect_time);
345: /* Resource Dimension */
346: purge_it_OADW('PA_LOWEST_RLMEM_IT',earliest_collect_time);
347: purge_it_OADW('PA_TOP_RLMEM_IT',earliest_collect_time);
348: purge_it_OADW('PA_RES_LISTS_IT_ALL_BG',earliest_collect_time);

Line 500: DELETE FROM PA_ALL_PRJ_TYPES_IT

496:
497: DELETE FROM PA_ALL_SRVC_TYPES_IT
498: WHERE STATUS_CODE = 'T';
499:
500: DELETE FROM PA_ALL_PRJ_TYPES_IT
501: WHERE STATUS_CODE = 'T';
502:
503: DELETE FROM PA_PRJ_ORGS_IT
504: WHERE STATUS_CODE = 'T';