DBA Data[Home] [Help]

APPS.PJI_RM_SUM_ROLLUP_RES dependencies on PJI_RM_REXT_FCSTITEM

Line 65: insert /*+ append parallel(fcst_i) */ into PJI_RM_REXT_FCSTITEM fcst_i

61: where CHANGE_TYPE = 'Y';
62:
63: if (l_row_count > 0) then
64:
65: insert /*+ append parallel(fcst_i) */ into PJI_RM_REXT_FCSTITEM fcst_i
66: (
67: WORKER_ID,
68: FID_ROWID,
69: START_DATE,

Line 89: PJI_RM_REXT_FCSTITEM fcst,

85: from
86: PJI_RES_DELTA delta,
87: PA_FORECAST_ITEMS fi,
88: PA_FORECAST_ITEM_DETAILS fid,
89: PJI_RM_REXT_FCSTITEM fcst,
90: PJI_ORG_EXTR_STATUS status
91: where
92: delta.CHANGE_TYPE = 'Y' and
93: fi.RESOURCE_ID = delta.RESOURCE_ID and