APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_AC_AGGR_PJP0

Line 7680: insert into PJI_AC_AGGR_PJP0 pjp0_i

7676:
7677: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
7678: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
7679:
7680: insert into PJI_AC_AGGR_PJP0 pjp0_i
7681: (
7682: WORKER_ID,
7683: PROJECT_ID,
7684: PROJECT_ORG_ID,

Line 8327: from PJI_AC_AGGR_PJP0

8323: where WORKER_ID = p_worker_id
8324: union
8325: select distinct
8326: PROJECT_ID
8327: from PJI_AC_AGGR_PJP0
8328: where WORKER_ID = p_worker_id);
8329:
8330: if (l_extraction_type = 'PARTIAL' or
8331: l_extraction_type = 'RBS') then

Line 8353: from PJI_AC_AGGR_PJP0

8349: where WORKER_ID = p_worker_id
8350: union
8351: select distinct
8352: PROJECT_ID
8353: from PJI_AC_AGGR_PJP0
8354: where WORKER_ID = p_worker_id
8355: union
8356: select distinct
8357: PROJECT_ID

Line 9163: fnd_stats.gather_table_stats('PJI','PJI_AC_AGGR_PJP0',PERCENT=>40);

9159: l_refresh_code := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER (l_process, 'REFRESH_CODE');
9160: l_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER (l_process, 'PLAN_TYPE_ID');
9161:
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);

Line 9355: PJI_AC_AGGR_PJP0

9351: to_number(null) CUSTOM13,
9352: to_number(null) CUSTOM14,
9353: to_number(null) CUSTOM15
9354: from
9355: PJI_AC_AGGR_PJP0
9356: where
9357: WORKER_ID = p_worker_id
9358: union all
9359: select

Line 9719: PJI_AC_AGGR_PJP0

9715: to_number(null) CUSTOM13,
9716: to_number(null) CUSTOM14,
9717: to_number(null) CUSTOM15
9718: from
9719: PJI_AC_AGGR_PJP0
9720: where
9721: WORKER_ID = p_worker_id
9722: union all
9723: select

Line 9893: PJI_AC_AGGR_PJP0 pjp0, -- Re-orderdered the tables for bug 15996434

9889: to_number(null) CUSTOM13,
9890: to_number(null) CUSTOM14,
9891: to_number(null) CUSTOM15
9892: from
9893: PJI_AC_AGGR_PJP0 pjp0, -- Re-orderdered the tables for bug 15996434
9894: PJI_TIME_ENT_PERIOD_V ent,
9895: PJI_TIME_RPT_STRUCT cal,
9896: PJI_AC_XBS_ACCUM_F acr,
9897: PJI_PJP_PROJ_BATCH_MAP map,

Line 10036: PJI_AC_AGGR_PJP0 pjp0, -- Re-orderdered the tables for bug 15996434

10032: to_number(null) CUSTOM13,
10033: to_number(null) CUSTOM14,
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,

Line 10183: PJI_AC_AGGR_PJP0 pjp0, -- Re-orderdered the tables for bug 15996434

10179: to_number(null) CUSTOM13,
10180: to_number(null) CUSTOM14,
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,

Line 20321: 'PJI_AC_AGGR_PJP0',

20317: l_tab3 := 'Y';
20318: end if;
20319: if l_tab4 = 'N' then
20320: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
20321: 'PJI_AC_AGGR_PJP0',
20322: 'PARTITION',
20323: 'P' || p_worker_id);
20324: l_tab4 := 'Y';
20325: end if;