APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_AC_AGGR_PJP0

Line 4414: insert into PJI_AC_AGGR_PJP0 pjp0_i

4410:
4411: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
4412: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
4413:
4414: insert into PJI_AC_AGGR_PJP0 pjp0_i
4415: (
4416: WORKER_ID,
4417: PROJECT_ID,
4418: PROJECT_ORG_ID,

Line 5060: from PJI_AC_AGGR_PJP0

5056: where WORKER_ID = p_worker_id
5057: union
5058: select distinct
5059: PROJECT_ID
5060: from PJI_AC_AGGR_PJP0
5061: where WORKER_ID = p_worker_id);
5062:
5063: if (l_extraction_type = 'PARTIAL' or
5064: l_extraction_type = 'RBS') then

Line 5086: from PJI_AC_AGGR_PJP0

5082: where WORKER_ID = p_worker_id
5083: union
5084: select distinct
5085: PROJECT_ID
5086: from PJI_AC_AGGR_PJP0
5087: where WORKER_ID = p_worker_id
5088: union
5089: select distinct
5090: PROJECT_ID

Line 6063: PJI_AC_AGGR_PJP0

6059: to_number(null) CUSTOM13,
6060: to_number(null) CUSTOM14,
6061: to_number(null) CUSTOM15
6062: from
6063: PJI_AC_AGGR_PJP0
6064: where
6065: WORKER_ID = p_worker_id
6066: union all
6067: select

Line 6427: PJI_AC_AGGR_PJP0

6423: to_number(null) CUSTOM13,
6424: to_number(null) CUSTOM14,
6425: to_number(null) CUSTOM15
6426: from
6427: PJI_AC_AGGR_PJP0
6428: where
6429: WORKER_ID = p_worker_id
6430: union all
6431: select

Line 6603: PJI_AC_AGGR_PJP0 pjp0, -- Bug 6689297

6599: to_number(null) CUSTOM15
6600: from
6601: PJI_PJP_PROJ_BATCH_MAP map,
6602: PJI_AC_XBS_ACCUM_F acr,
6603: PJI_AC_AGGR_PJP0 pjp0, -- Bug 6689297
6604: PJI_TIME_RPT_STRUCT cal,
6605: PJI_TIME_ENT_PERIOD_V ent,
6606: (
6607: select 'ACTIVITY' INVERT_ID from DUAL union all

Line 6746: PJI_AC_AGGR_PJP0 pjp0, -- Bug 6689297

6742: to_number(null) CUSTOM15
6743: from
6744: PJI_PJP_PROJ_BATCH_MAP map,
6745: PJI_AC_XBS_ACCUM_F acr,
6746: PJI_AC_AGGR_PJP0 pjp0, -- Bug 6689297
6747: PJI_TIME_CAL_RPT_STRUCT cal,
6748: PJI_ORG_EXTR_INFO info,
6749: PJI_TIME_CAL_PERIOD_V gl_cal,
6750: (

Line 6893: PJI_AC_AGGR_PJP0 pjp0, -- Bug 6689297

6889: to_number(null) CUSTOM15
6890: from
6891: PJI_PJP_PROJ_BATCH_MAP map,
6892: PJI_AC_XBS_ACCUM_F acr,
6893: PJI_AC_AGGR_PJP0 pjp0, -- Bug 6689297
6894: PJI_TIME_CAL_RPT_STRUCT cal,
6895: PJI_ORG_EXTR_INFO info,
6896: PJI_TIME_CAL_PERIOD_V pa_cal,
6897: (

Line 18000: 'PJI_AC_AGGR_PJP0',

17996: 'PARTITION',
17997: 'P' || p_worker_id);
17998:
17999: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
18000: 'PJI_AC_AGGR_PJP0',
18001: 'PARTITION',
18002: 'P' || p_worker_id);
18003:
18004: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,