APPS.PJI_PJP_EXTRACTION_UTILS dependencies on PA_XBS_DENORM

Line 228: from PA_XBS_DENORM den

224: PA_PROJECTS_ALL prj
225: where
226: prj.TEMPLATE_FLAG = 'N' and
227: not exists (select 1
228: from PA_XBS_DENORM den
229: where den.STRUCT_TYPE = 'PRG' and
230: den.SUP_PROJECT_ID = prj.PROJECT_ID) and
231: not exists (select 1
232: from PA_PJI_PROJ_EVENTS_LOG log

Line 440: tabname => 'PA_XBS_DENORM',

436: percent => 10,
437: degree => l_degree);
438:
439: FND_STATS.GATHER_TABLE_STATS(ownname => l_pa_schema,
440: tabname => 'PA_XBS_DENORM',
441: percent => 10,
442: degree => l_degree);
443:
444: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,

Line 591: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pa_schema, 'PA_XBS_DENORM', 'NORMAL', null);

587: delete from PA_PJI_PROJ_EVENTS_LOG where event_type = 'PLANTYPE_UPG'; /*4882640 */
588: -------------------
589:
590: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FP_AGGR_XBS', 'NORMAL', null);
591: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pa_schema, 'PA_XBS_DENORM', 'NORMAL', null);
592: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_XBS_DENORM', 'NORMAL', null);
593: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_XBS_DENORM_DELTA', 'NORMAL', null);
594: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FP_AGGR_RBS', 'NORMAL', null);
595: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pa_schema, 'PA_RBS_DENORM', 'NORMAL', null);