DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_MAIN dependencies on PA_LOWEST_RLMEM_IT

Line 222: DELETE FROM PA_LOWEST_RLMEM_IT;

218: DELETE FROM PA_EXP_TYPES_IT;
219: DELETE FROM PA_PRJ_CLASSES_IT;
220: DELETE FROM PA_CLASS_CATGS_IT;
221: DELETE FROM PA_CLASS_CODES_IT;
222: DELETE FROM PA_LOWEST_RLMEM_IT;
223: DELETE FROM PA_TOP_RLMEM_IT;
224: DELETE FROM PA_RES_LISTS_IT;
225: DELETE FROM PA_SRVC_TYPES_IT;
226: DELETE FROM PA_PERIODS_IT;

Line 346: purge_it_OADW('PA_LOWEST_RLMEM_IT',earliest_collect_time);

342: purge_it_OADW('PA_PROJECTS_IT_ALL',earliest_collect_time);
343: purge_it_OADW('PA_PRJ_TYPES_IT_ALL',earliest_collect_time);
344: purge_it_OADW('PA_ALL_PRJ_TYPES_IT',earliest_collect_time);
345: /* Resource Dimension */
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);

Line 446: DELETE FROM PA_LOWEST_RLMEM_IT

442:
443: DELETE FROM PA_CLASS_CODES_IT
444: WHERE STATUS_CODE = 'T';
445:
446: DELETE FROM PA_LOWEST_RLMEM_IT
447: WHERE STATUS_CODE = 'T';
448:
449: DELETE FROM PA_TOP_RLMEM_IT
450: WHERE STATUS_CODE = 'T';