APPS.PA_ADW_COLLECT_MAIN dependencies on PA_FINANCIAL_QTRS_IT

Line 236: DELETE FROM PA_FINANCIAL_QTRS_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;
240: DELETE FROM PA_ALL_SRVC_TYPES_IT;

Line 354: purge_it_OADW('PA_FINANCIAL_QTRS_IT',earliest_collect_time);

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 */
358: IF (collect_top_tasks_flag = 'Y' OR collect_lowest_tasks_flag = 'Y') THEN

Line 485: DELETE FROM PA_FINANCIAL_QTRS_IT

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