APPS.PJI_RM_SUM_EXTR dependencies on PJI_RM_AGGR_RES3

Line 983: insert /*+ append parallel(res3_i) */ into PJI_RM_AGGR_RES3 res3_i

979: )) then
980: return;
981: end if;
982:
983: insert /*+ append parallel(res3_i) */ into PJI_RM_AGGR_RES3 res3_i
984: (
985: WORKER_ID,
986: PROJECT_ID,
987: PERSON_ID,

Line 1316: PJI_RM_AGGR_RES3 tmp3,

1312: when invert.INVERT_ID = 'RMR'
1313: then -rmr.PROV_OVERCOM_HRS_S
1314: end PROV_OVERCOM_HRS_S
1315: from
1316: PJI_RM_AGGR_RES3 tmp3,
1317: PJI_RM_RES_WT_F rmr,
1318: PJI_RES_DELTA delta,
1319: (
1320: select 'TMP3' INVERT_ID from dual union all

Line 1338: select /*+ ordered index(tmp3, PJI_RM_AGGR_RES3_N1)

1334: rmr.TIME_ID >= to_number(to_char(delta.START_DATE (+), 'J')) and
1335: rmr.TIME_ID <= to_number(to_char(delta.END_DATE (+), 'J')) and
1336: delta.PERSON_ID is null
1337: union all -- JOB_ID lookups for assignments in tmp1
1338: select /*+ ordered index(tmp3, PJI_RM_AGGR_RES3_N1)
1339: index(rmr, PJI_RM_RES_WT_F_N2)
1340: parallel(rmr) */
1341: 'A' RECORD_TYPE,
1342: tmp1.PROJECT_ID,

Line 1363: PJI_RM_AGGR_RES3 tmp3,

1359: tmp1.CONF_OVERCOM_HRS_S,
1360: tmp1.PROV_OVERCOM_HRS_S
1361: from
1362: PJI_RM_AGGR_RES1 tmp1,
1363: PJI_RM_AGGR_RES3 tmp3,
1364: PJI_RM_RES_WT_F rmr
1365: where
1366: tmp1.WORKER_ID = p_worker_id and
1367: tmp1.RECORD_TYPE = 'N' and

Line 1700: 'PJI_RM_AGGR_RES3',

1696: 'NORMAL',
1697: null);
1698:
1699: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1700: 'PJI_RM_AGGR_RES3',
1701: 'NORMAL',
1702: null);
1703:
1704: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,