APPS.PJI_PJP_EXTRACTION_UTILS dependencies on PA_XBS_DENORM

Line 265: from PA_XBS_DENORM den

261: PJI_PROJ_EXTR_STATUS fm_status /* Added for bug 8661279 */
262: where
263: prj.TEMPLATE_FLAG = 'N' and
264: not exists (select 1
265: from PA_XBS_DENORM den
266: where den.STRUCT_TYPE = 'PRG' and
267: den.SUP_PROJECT_ID = prj.PROJECT_ID) /*and
268: not exists (select 1
269: from PA_PJI_PROJ_EVENTS_LOG log

Line 482: tabname => 'PA_XBS_DENORM',

478: percent => 10,
479: degree => l_degree);
480:
481: FND_STATS.GATHER_TABLE_STATS(ownname => l_pa_schema,
482: tabname => 'PA_XBS_DENORM',
483: percent => 10,
484: degree => l_degree);
485:
486: FND_STATS.GATHER_TABLE_STATS(ownname => l_pji_schema,

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

629: delete from PA_PJI_PROJ_EVENTS_LOG where event_type = 'PLANTYPE_UPG'; /*4882640 */
630: -------------------
631:
632: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FP_AGGR_XBS', 'NORMAL', null);
633: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pa_schema, 'PA_XBS_DENORM', 'NORMAL', null);
634: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_XBS_DENORM', 'NORMAL', null);
635: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_XBS_DENORM_DELTA', 'NORMAL', null);
636: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FP_AGGR_RBS', 'NORMAL', null);
637: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pa_schema, 'PA_RBS_DENORM', 'NORMAL', null);