DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_MAIN dependencies on PA_BGT_TYPES_IT

Line 228: DELETE FROM PA_BGT_TYPES_IT;

224: DELETE FROM PA_RES_LISTS_IT;
225: DELETE FROM PA_SRVC_TYPES_IT;
226: DELETE FROM PA_PERIODS_IT;
227: DELETE FROM PA_ORGS_IT;
228: DELETE FROM PA_BGT_TYPES_IT;
229: DELETE FROM PA_TSK_ACT_CMT_IT;
230: DELETE FROM PA_PRJ_ACT_CMT_IT;
231: DELETE FROM PA_TSK_BGT_LINES_IT;
232: DELETE FROM PA_PRJ_BGT_LINES_IT;

Line 350: purge_it_OADW('PA_BGT_TYPES_IT',earliest_collect_time);

346: purge_it_OADW('PA_LOWEST_RLMEM_IT',earliest_collect_time);
347: purge_it_OADW('PA_TOP_RLMEM_IT',earliest_collect_time);
348: purge_it_OADW('PA_RES_LISTS_IT_ALL_BG',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);

Line 464: DELETE FROM PA_BGT_TYPES_IT

460:
461: DELETE FROM PA_ORGS_IT
462: WHERE STATUS_CODE = 'T';
463:
464: DELETE FROM PA_BGT_TYPES_IT
465: WHERE STATUS_CODE = 'T';
466:
467: DELETE FROM PA_TSK_ACT_CMT_IT
468: WHERE STATUS_CODE = 'T';