DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_MAIN dependencies on PA_GL_PERIODS_IT

Line 235: DELETE FROM PA_GL_PERIODS_IT;

231: DELETE FROM PA_TSK_BGT_LINES_IT;
232: DELETE FROM PA_PRJ_BGT_LINES_IT;
233: DELETE FROM PA_OLD_RES_ACCUM_DTLS;
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;

Line 353: purge_it_OADW('PA_GL_PERIODS_IT',earliest_collect_time);

349: /* Budget Type Dimension */
350: purge_it_OADW('PA_BGT_TYPES_IT',earliest_collect_time);
351: /* Time Dimension */
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 */

Line 482: DELETE FROM PA_GL_PERIODS_IT

478:
479: DELETE FROM PA_OPER_UNITS_IT
480: WHERE STATUS_CODE = 'T';
481:
482: DELETE FROM PA_GL_PERIODS_IT
483: WHERE STATUS_CODE = 'T';
484:
485: DELETE FROM PA_FINANCIAL_QTRS_IT
486: WHERE STATUS_CODE = 'T';