APPS.PA_ADW_COLLECT_MAIN dependencies on PA_FINANCIAL_YRS_IT

Line 237: DELETE FROM PA_FINANCIAL_YRS_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;
241: DELETE FROM PA_ALL_PRJ_TYPES_IT;

Line 355: purge_it_OADW('PA_FINANCIAL_YRS_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
359: purge_it_OADW('PA_TSK_ACT_CMT_IT_ALL',earliest_collect_time);

Line 488: DELETE FROM PA_FINANCIAL_YRS_IT

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';
490:
491: DELETE FROM PA_ALL_FINANCIAL_YRS_IT
492: WHERE STATUS_CODE = 'T';