APPS.PA_ADW_COLLECT_MAIN dependencies on PA_PRJ_ORGS_IT

Line 242: DELETE FROM PA_PRJ_ORGS_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;
246: DELETE FROM PA_SET_OF_BOOKS_IT;

Line 378: purge_it_OADW('PA_PRJ_ORGS_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
378: purge_it_OADW('PA_PRJ_ORGS_IT',earliest_collect_time);
379: purge_it_OADW('PA_PRJ_BUSINESS_GRPS_IT',earliest_collect_time);
380: END IF;
381: /* Expenditure Organization Dimension */
382: IF (dim_exp_org = 'E') THEN

Line 503: DELETE FROM PA_PRJ_ORGS_IT

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';
505:
506: DELETE FROM PA_PRJ_BUSINESS_GRPS_IT
507: WHERE STATUS_CODE = 'T';