DBA Data[Home] [Help]

APPS.PJI_RM_SUM_EXTR dependencies on PJI_RESOURCES_DENORM

Line 156: PJI_RESOURCES_DENORM denorm

152: res6.ROWID STG_ROWID
153: from
154: PJI_PJI_PROJ_BATCH_MAP map,
155: PJI_RM_AGGR_RES6 res6,
156: PJI_RESOURCES_DENORM denorm
157: where
158: map.WORKER_ID = p_worker_id and
159: res6.PROJECT_ID = map.PROJECT_ID and
160: res6.PERSON_ID = denorm.PERSON_ID and

Line 364: PJI_RESOURCES_DENORM res,

360: from
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

Line 776: PJI_RESOURCES_DENORM res,

772: PJI_RM_REXT_FCSTITEM scope,
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