APPS.PJI_RM_SUM_EXTR dependencies on PJI_RM_RES_WT_F

Line 1123: PJI_RM_RES_WT_F rmr,

1119: -rmr.CONF_OVERCOM_HRS_S CONF_OVERCOM_HRS_S,
1120: -rmr.PROV_OVERCOM_HRS_S PROV_OVERCOM_HRS_S
1121: from
1122: PJI_RM_ORG_BATCH_MAP map,
1123: PJI_RM_RES_WT_F rmr,
1124: PJI_ORG_EXTR_INFO info
1125: where
1126: l_extraction_type = 'PARTIAL' and
1127: map.WORKER_ID = p_worker_id and

Line 1160: PJI_RM_RES_WT_F rmr,

1156: to_number(null) CONF_OVERCOM_HRS_S,
1157: to_number(null) PROV_OVERCOM_HRS_S
1158: from
1159: PJI_PJI_PROJ_BATCH_MAP map,
1160: PJI_RM_RES_WT_F rmr,
1161: PJI_ORG_EXTR_INFO info
1162: where
1163: l_extraction_type = 'PARTIAL' and
1164: map.WORKER_ID = p_worker_id and

Line 1196: PJI_RM_RES_WT_F rmr,

1192: -rmr.CONF_OVERCOM_HRS_S CONF_OVERCOM_HRS_S,
1193: -rmr.PROV_OVERCOM_HRS_S PROV_OVERCOM_HRS_S
1194: from
1195: PJI_RES_DELTA delta,
1196: PJI_RM_RES_WT_F rmr,
1197: PJI_RM_ORG_BATCH_MAP map,
1198: PJI_PJI_PROJ_BATCH_MAP fm_map,
1199: PJI_ORG_EXTR_INFO info
1200: where

Line 1245: PJI_RM_RES_WT_F rmr,

1241: -rmr.CONF_OVERCOM_HRS_S,
1242: -rmr.PROV_OVERCOM_HRS_S
1243: from
1244: PJI_RES_DELTA delta,
1245: PJI_RM_RES_WT_F rmr,
1246: PJI_ORG_EXTR_INFO info
1247: where
1248: l_extraction_type = 'INCREMENTAL' and
1249: delta.CHANGE_TYPE = 'N' and

Line 1317: PJI_RM_RES_WT_F 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
1321: select 'RMR' INVERT_ID from dual

Line 1339: index(rmr, PJI_RM_RES_WT_F_N2)

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,
1343: tmp1.PERSON_ID,

Line 1364: PJI_RM_RES_WT_F rmr

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
1368: p_worker_id = tmp3.WORKER_ID (+) and

Line 1383: index(rmr, PJI_RM_RES_WT_F_N3)

1379: tmp1.PERIOD_TYPE_ID = rmr.PERIOD_TYPE_ID (+) and
1380: tmp1.CALENDAR_TYPE = rmr.CALENDAR_TYPE (+)
1381: union all -- reversals for deleted projects
1382: select /*+ ordered
1383: index(rmr, PJI_RM_RES_WT_F_N3)
1384: full(delta)
1385: full(info)
1386: */
1387: rmr.RECORD_TYPE,

Line 1413: select /*+ index_ffs(rmr, PJI_RM_RES_WT_F_N3)

1409: select
1410: PROJECT_ID
1411: from
1412: (
1413: select /*+ index_ffs(rmr, PJI_RM_RES_WT_F_N3)
1414: parallel_index(rmr, PJI_RM_RES_WT_F_N3) */
1415: distinct
1416: PROJECT_ID
1417: from

Line 1414: parallel_index(rmr, PJI_RM_RES_WT_F_N3) */

1410: PROJECT_ID
1411: from
1412: (
1413: select /*+ index_ffs(rmr, PJI_RM_RES_WT_F_N3)
1414: parallel_index(rmr, PJI_RM_RES_WT_F_N3) */
1415: distinct
1416: PROJECT_ID
1417: from
1418: PJI_RM_RES_WT_F rmr

Line 1418: PJI_RM_RES_WT_F rmr

1414: parallel_index(rmr, PJI_RM_RES_WT_F_N3) */
1415: distinct
1416: PROJECT_ID
1417: from
1418: PJI_RM_RES_WT_F rmr
1419: where
1420: PROJECT_ID is not null and
1421: PROJECT_ID <> -1
1422: ) pji

Line 1428: PJI_RM_RES_WT_F rmr,

1424: not exists (select 1
1425: from PA_PROJECTS_ALL pa
1426: where pa.PROJECT_ID = pji.PROJECT_ID)
1427: ) prj,
1428: PJI_RM_RES_WT_F rmr,
1429: PJI_RES_DELTA delta,
1430: PJI_ORG_EXTR_INFO info
1431: where
1432: l_extraction_type = 'INCREMENTAL' and