APPS.PA_ADW_COLLECT_MAIN dependencies on PA_ALL_EXP_TYPES_IT

Line 239: DELETE FROM PA_ALL_EXP_TYPES_IT;

235: DELETE FROM PA_GL_PERIODS_IT;
236: DELETE FROM PA_FINANCIAL_QTRS_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;

Line 369: purge_it_OADW('PA_ALL_EXP_TYPES_IT',earliest_collect_time);

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
373: purge_it_OADW('PA_SRVC_TYPES_IT',earliest_collect_time);

Line 494: DELETE FROM PA_ALL_EXP_TYPES_IT

490:
491: DELETE FROM PA_ALL_FINANCIAL_YRS_IT
492: WHERE STATUS_CODE = 'T';
493:
494: DELETE FROM PA_ALL_EXP_TYPES_IT
495: WHERE STATUS_CODE = 'T';
496:
497: DELETE FROM PA_ALL_SRVC_TYPES_IT
498: WHERE STATUS_CODE = 'T';