APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_FP_AGGR_PJP0

Line 6523: insert /*+ parallel(pjp0_i) */ into PJI_FP_AGGR_PJP0 pjp0_i /* Added for bug 13030627 */

6519:
6520: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
6521: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
6522:
6523: insert /*+ parallel(pjp0_i) */ into PJI_FP_AGGR_PJP0 pjp0_i /* Added for bug 13030627 */
6524: (
6525: WORKER_ID,
6526: TXN_ACCUM_HEADER_ID,
6527: PROJECT_ID,

Line 8322: from PJI_FP_AGGR_PJP0

8318: LAST_UPDATE_LOGIN = l_last_update_login
8319: where nvl(PJI_SOURCE_FLAG, 'X') <> 'Y' and
8320: PROJECT_ID in (select distinct
8321: PROJECT_ID
8322: from PJI_FP_AGGR_PJP0
8323: where WORKER_ID = p_worker_id
8324: union
8325: select distinct
8326: PROJECT_ID

Line 8348: from PJI_FP_AGGR_PJP0

8344: where WORKER_ID = p_worker_id and
8345: PJI_PROJECT_STATUS is null and
8346: PROJECT_ID in (select distinct
8347: PROJECT_ID
8348: from PJI_FP_AGGR_PJP0
8349: where WORKER_ID = p_worker_id
8350: union
8351: select distinct
8352: PROJECT_ID

Line 8779: PJI_FP_AGGR_PJP0

8775: to_number(null) CUSTOM13,
8776: to_number(null) CUSTOM14,
8777: to_number(null) CUSTOM15
8778: from
8779: PJI_FP_AGGR_PJP0
8780: where
8781: WORKER_ID = p_worker_id
8782: union all
8783: select

Line 20314: 'PJI_FP_AGGR_PJP0',

20310: l_tab2 := 'Y';
20311: end if;
20312: if l_tab3 = 'N' then
20313: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
20314: 'PJI_FP_AGGR_PJP0',
20315: 'PARTITION',
20316: 'P' || p_worker_id);
20317: l_tab3 := 'Y';
20318: end if;