APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_ORG_EXTR_INFO

Line 7525: PJI_ORG_EXTR_INFO info,

7521: ) src2
7522: ) src,
7523: PA_RBS_TXN_ACCUM_MAP rbs,
7524: PJI_PJP_PROJ_BATCH_MAP map,
7525: PJI_ORG_EXTR_INFO info,
7526: PJI_PJP_WBS_HEADER wbs_hdr,
7527: PA_PROJ_ELEMENT_VERSIONS ver,
7528: (
7529: select 1 INVERT_ID from dual

Line 8207: PJI_ORG_EXTR_INFO info

8203: from
8204: PJI_PJP_RMAP_ACR src_r,
8205: PJI_FM_AGGR_ACT4 src,
8206: PA_PROJECTS_ALL prj,
8207: PJI_ORG_EXTR_INFO info
8208: where
8209: src_r.WORKER_ID = p_worker_id and
8210: src.ROWID = src_r.STG_ROWID and
8211: src.PROJECT_ID = prj.PROJECT_ID and

Line 9166: fnd_stats.gather_table_stats('PJI','PJI_ORG_EXTR_INFO',PERCENT=>40);

9162: -- Bug 15881881
9163: fnd_stats.gather_table_stats('PJI','PJI_AC_AGGR_PJP0',PERCENT=>40);
9164: fnd_stats.gather_table_stats('PJI','PJI_AC_CUST_PJP0',PERCENT=>40);
9165: fnd_stats.gather_table_stats('PJI','PJI_AC_XBS_ACCUM_F',PERCENT=>40);
9166: fnd_stats.gather_table_stats('PJI','PJI_ORG_EXTR_INFO',PERCENT=>40);
9167: fnd_stats.gather_table_stats('PJI','PJI_PJP_PROJ_BATCH_MAP',PERCENT=>40);
9168: fnd_stats.gather_table_stats('PJI','PJI_TIME_CAL_PERIOD',PERCENT=>40);
9169: fnd_stats.gather_table_stats('PJI','PJI_TIME_CAL_RPT_STRUCT',PERCENT=>40);
9170: fnd_stats.gather_table_stats('PJI','PJI_TIME_ENT_PERIOD',PERCENT=>40);

Line 10038: PJI_ORG_EXTR_INFO info,

10034: to_number(null) CUSTOM15
10035: from
10036: PJI_AC_AGGR_PJP0 pjp0, -- Re-orderdered the tables for bug 15996434
10037: PJI_AC_XBS_ACCUM_F acr,
10038: PJI_ORG_EXTR_INFO info,
10039: PJI_TIME_CAL_PERIOD_V gl_cal,
10040: PJI_TIME_CAL_RPT_STRUCT cal,
10041: PJI_PJP_PROJ_BATCH_MAP map,
10042: (

Line 10185: PJI_ORG_EXTR_INFO info,

10181: to_number(null) CUSTOM15
10182: from
10183: PJI_AC_AGGR_PJP0 pjp0, -- Re-orderdered the tables for bug 15996434
10184: PJI_AC_XBS_ACCUM_F acr,
10185: PJI_ORG_EXTR_INFO info,
10186: PJI_TIME_CAL_PERIOD_V pa_cal,
10187: PJI_TIME_CAL_RPT_STRUCT cal,
10188: PJI_PJP_PROJ_BATCH_MAP map,
10189: (