APPS.PJI_RM_SUM_EXTR dependencies on PJI_PJI_RMAP_RES

Line 145: insert /*+ append parallel(res_i) */ into PJI_PJI_RMAP_RES res_i

141: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_RM_SUM_EXTR.RES_ROWID_TABLE(p_worker_id);')) then
142: return;
143: end if;
144:
145: insert /*+ append parallel(res_i) */ into PJI_PJI_RMAP_RES res_i
146: (
147: WORKER_ID,
148: STG_ROWID
149: )

Line 402: PJI_PJI_RMAP_RES res6_r

398: res6.WORK_TYPE_ID,
399: res6.PROJECT_ID
400: from
401: PJI_RM_AGGR_RES6 res6,
402: PJI_PJI_RMAP_RES res6_r
403: where
404: res6_r.WORKER_ID = p_worker_id and
405: res6.ROWID = res6_r.STG_ROWID
406: ) tmp1

Line 816: PJI_PJI_RMAP_RES res6_r,

812: res6.JOB_ID,
813: res6.WORK_TYPE_ID,
814: res6.PROJECT_ID
815: from
816: PJI_PJI_RMAP_RES res6_r,
817: PJI_RM_AGGR_RES6 res6
818: where
819: res6_r.WORKER_ID = p_worker_id and
820: res6.ROWID = res6_r.STG_ROWID

Line 951: from PJI_PJI_RMAP_RES

947:
948: delete
949: from PJI_RM_AGGR_RES6
950: where ROWID in (select STG_ROWID
951: from PJI_PJI_RMAP_RES
952: where WORKER_ID = p_worker_id);
953:
954: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_RM_SUM_EXTR.PURGE_RES_DATA(p_worker_id);');
955:

Line 1685: 'PJI_PJI_RMAP_RES',

1681: 'NORMAL',
1682: null);
1683:
1684: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1685: 'PJI_PJI_RMAP_RES',
1686: 'NORMAL',
1687: null);
1688:
1689: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,