DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_MAIN dependencies on PA_ALL_FINANCIAL_YRS_IT

Line 238: DELETE FROM PA_ALL_FINANCIAL_YRS_IT;

234: DELETE FROM PA_OPER_UNITS_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;

Line 356: purge_it_OADW('PA_ALL_FINANCIAL_YRS_IT',earliest_collect_time);

352: purge_it_OADW('PA_PERIODS_IT',earliest_collect_time);
353: purge_it_OADW('PA_GL_PERIODS_IT',earliest_collect_time);
354: purge_it_OADW('PA_FINANCIAL_QTRS_IT',earliest_collect_time);
355: purge_it_OADW('PA_FINANCIAL_YRS_IT',earliest_collect_time);
356: purge_it_OADW('PA_ALL_FINANCIAL_YRS_IT',earliest_collect_time);
357: /* Fact Tables */
358: IF (collect_top_tasks_flag = 'Y' OR collect_lowest_tasks_flag = 'Y') THEN
359: purge_it_OADW('PA_TSK_ACT_CMT_IT_ALL',earliest_collect_time);
360: END IF;

Line 491: DELETE FROM PA_ALL_FINANCIAL_YRS_IT

487:
488: DELETE FROM PA_FINANCIAL_YRS_IT
489: WHERE STATUS_CODE = 'T';
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';