DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_MAIN dependencies on PA_EXP_BUSINESS_GRPS_IT

Line 245: DELETE FROM PA_EXP_BUSINESS_GRPS_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;
247: DELETE FROM PA_LEGAL_ENTITY_IT;
248:
249: x_err_stack := x_old_err_stack;

Line 384: purge_it_OADW('PA_EXP_BUSINESS_GRPS_IT',earliest_collect_time);

380: END IF;
381: /* Expenditure Organization Dimension */
382: IF (dim_exp_org = 'E') THEN
383: purge_it_OADW('PA_EXP_ORGS_IT',earliest_collect_time);
384: purge_it_OADW('PA_EXP_BUSINESS_GRPS_IT',earliest_collect_time);
385: END IF;
386: /* Operating Unit Dimension */
387: IF (dim_operating_unit = 'E') THEN
388: purge_it_OADW('PA_SET_OF_BOOKS_IT',earliest_collect_time);

Line 512: DELETE FROM PA_EXP_BUSINESS_GRPS_IT

508:
509: DELETE FROM PA_EXP_ORGS_IT
510: WHERE STATUS_CODE = 'T';
511:
512: DELETE FROM PA_EXP_BUSINESS_GRPS_IT
513: WHERE STATUS_CODE = 'T';
514:
515: DELETE FROM PA_SET_OF_BOOKS_IT
516: WHERE STATUS_CODE = 'T';