APPS.PJI_RM_SUM_EXTR dependencies on PJI_ORG_EXTR_INFO

Line 79: PJI_ORG_EXTR_INFO res_map

75: tmp1.PROV_OVERCOM_HRS_S
76: from
77: PJI_RM_DNGL_RES tmp1,
78: PJI_RM_ORG_BATCH_MAP orgs,
79: PJI_ORG_EXTR_INFO res_map
80: where
81: tmp1.WORKER_ID = 0 and
82: orgs.WORKER_ID = p_worker_id and
83: orgs.ORGANIZATION_ID = tmp1.EXPENDITURE_ORGANIZATION_ID and

Line 365: PJI_ORG_EXTR_INFO res_info

361: PJI_RM_WORK_TYPE_INFO wt,
362: PA_FORECAST_ITEM_DETAILS fid,
363: PA_FORECAST_ITEMS fi,
364: PJI_RESOURCES_DENORM res,
365: PJI_ORG_EXTR_INFO res_info
366: where
367: nvl(fid.pji_summarized_flag,'Y') <> 'N' and
368: fi.FORECAST_ITEM_ID = fid.FORECAST_ITEM_ID and
369: fi.FORECAST_ITEM_TYPE in ('U', 'A') and

Line 777: PJI_ORG_EXTR_INFO res_info

773: PA_FORECAST_ITEM_DETAILS fid,
774: PA_FORECAST_ITEMS fi,
775: PJI_RM_WORK_TYPE_INFO wt,
776: PJI_RESOURCES_DENORM res,
777: PJI_ORG_EXTR_INFO res_info
778: where
779: scope.WORKER_ID = p_worker_id and
780: scope.fid_rowid = fid.rowid and
781: fi.FORECAST_ITEM_ID = fid.FORECAST_ITEM_ID and

Line 1124: PJI_ORG_EXTR_INFO info

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
1128: map.EXTRACTION_TYPE = 'P' and

Line 1161: PJI_ORG_EXTR_INFO info

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
1165: map.EXTRACTION_TYPE = 'P' and

Line 1199: PJI_ORG_EXTR_INFO info

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
1201: l_extraction_type = 'PARTIAL' and
1202: delta.CHANGE_TYPE = 'N' and
1203: delta.PERSON_ID = rmr.PERSON_ID and

Line 1246: PJI_ORG_EXTR_INFO info

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
1250: delta.PERSON_ID = rmr.PERSON_ID and

Line 1430: PJI_ORG_EXTR_INFO info

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
1433: rmr.PROJECT_ID = prj.PROJECT_ID and
1434: rmr.PERIOD_TYPE_ID = 1 and

Line 1760: tabname => 'PJI_ORG_EXTR_INFO',

1756:
1757: PJI_PJI_EXTRACTION_UTILS.POPULATE_ORG_EXTR_INFO;
1758:
1759: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1760: tabname => 'PJI_ORG_EXTR_INFO',
1761: percent => 10,
1762: degree => PJI_UTILS.
1763: GET_DEGREE_OF_PARALLELISM);
1764: FND_STATS.GATHER_INDEX_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

Line 1765: indname => 'PJI_ORG_EXTR_INFO_N1',

1761: percent => 10,
1762: degree => PJI_UTILS.
1763: GET_DEGREE_OF_PARALLELISM);
1764: FND_STATS.GATHER_INDEX_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1765: indname => 'PJI_ORG_EXTR_INFO_N1',
1766: percent => 10);
1767:
1768: -- Reset status for Availability helper workers
1769: PJI_RM_SUM_AVL.UPDATE_RES_STATUS;