APPS.PJI_RM_SUM_ROLLUP_RES dependencies on PJI_RES_DELTA

Line 32: tabname => 'PJI_RES_DELTA',

28: end if;
29:
30: -- implicit commit
31: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
32: tabname => 'PJI_RES_DELTA',
33: percent => 10,
34: degree => BIS_COMMON_PARAMETERS.
35: GET_DEGREE_OF_PARALLELISM);
36: -- implicit commit

Line 38: tabname => 'PJI_RES_DELTA',

34: degree => BIS_COMMON_PARAMETERS.
35: GET_DEGREE_OF_PARALLELISM);
36: -- implicit commit
37: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
38: tabname => 'PJI_RES_DELTA',
39: colname => 'CHANGE_TYPE',
40: percent => 10,
41: degree => BIS_COMMON_PARAMETERS.
42: GET_DEGREE_OF_PARALLELISM);

Line 45: tabname => 'PJI_RES_DELTA',

41: degree => BIS_COMMON_PARAMETERS.
42: GET_DEGREE_OF_PARALLELISM);
43: -- implicit commit
44: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
45: tabname => 'PJI_RES_DELTA',
46: colname => 'RESOURCE_ID',
47: percent => 10,
48: degree => BIS_COMMON_PARAMETERS.
49: GET_DEGREE_OF_PARALLELISM);

Line 52: tabname => 'PJI_RES_DELTA',

48: degree => BIS_COMMON_PARAMETERS.
49: GET_DEGREE_OF_PARALLELISM);
50: -- implicit commit
51: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
52: tabname => 'PJI_RES_DELTA',
53: colname => 'PERSON_ID',
54: percent => 10,
55: degree => BIS_COMMON_PARAMETERS.
56: GET_DEGREE_OF_PARALLELISM);

Line 60: from PJI_RES_DELTA

56: GET_DEGREE_OF_PARALLELISM);
57:
58: select count(*)
59: into l_row_count
60: from PJI_RES_DELTA
61: where CHANGE_TYPE = 'Y';
62:
63: if (l_row_count > 0) then
64:

Line 86: PJI_RES_DELTA delta,

82: delta.END_DATE,
83: fid.PJI_SUMMARIZED_FLAG,
84: ceil(ROWNUM / PJI_RM_SUM_MAIN.g_commit_threshold)
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

Line 128: PJI_RES_DELTA delta,

124: -1 PROJECT_ORGANIZATION_ID,
125: cdl.PJI_SUMMARIZED_FLAG,
126: ceil(ROWNUM / PJI_RM_SUM_MAIN.g_commit_threshold)
127: from
128: PJI_RES_DELTA delta,
129: PA_EXPENDITURES_ALL exp,
130: PA_EXPENDITURE_ITEMS_ALL ei,
131: PA_COST_DISTRIBUTION_LINES_ALL cdl,
132: PJI_FM_REXT_CDL rcdl,