APPS.PJI_RM_SUM_AVL dependencies on FND_STATS

Line 175: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

171: );
172: END LOOP;
173:
174: -- implicit commit
175: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
176: tabname => 'PJI_ROLL_WEEK_OFFSET',
177: percent => 100,
178: degree => 1);
179:

Line 4784: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

4780:
4781: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
4782:
4783: -- implicit commit
4784: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4785: tabname => 'PJI_RM_AGGR_RES2',
4786: percent => 10,
4787: degree => BIS_COMMON_PARAMETERS.
4788: GET_DEGREE_OF_PARALLELISM);

Line 4790: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

4786: percent => 10,
4787: degree => BIS_COMMON_PARAMETERS.
4788: GET_DEGREE_OF_PARALLELISM);
4789: -- implicit commit
4790: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4791: tabname => 'PJI_RM_AGGR_RES2',
4792: colname => 'PERSON_ID',
4793: percent => 10,
4794: degree => BIS_COMMON_PARAMETERS.

Line 4881: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

4877: SELECT DISTINCT person_id from PJI_RM_AGGR_RES2;
4878: END IF;
4879:
4880: -- implicit commit
4881: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4882: tabname => 'PJI_RM_RES_BATCH_MAP',
4883: percent => 10,
4884: degree => BIS_COMMON_PARAMETERS.
4885: GET_DEGREE_OF_PARALLELISM);

Line 4887: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

4883: percent => 10,
4884: degree => BIS_COMMON_PARAMETERS.
4885: GET_DEGREE_OF_PARALLELISM);
4886: -- implicit commit
4887: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4888: tabname => 'PJI_RM_RES_BATCH_MAP',
4889: colname => 'PERSON_ID',
4890: percent => 10,
4891: degree => BIS_COMMON_PARAMETERS.

Line 4947: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,

4943: if (l_p_degree = 1) then
4944: l_p_degree := 0;
4945: end if;
4946:
4947: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
4948: TABNAME => 'PJI_ORG_DENORM',
4949: PERCENT => 10,
4950: DEGREE => l_p_degree);
4951:

Line 4960: FND_STATS.GATHER_TABLE_STATS

4956: 'C',
4957: 'N');
4958: ELSE
4959:
4960: FND_STATS.GATHER_TABLE_STATS
4961: (OWNNAME => l_pji_schema,
4962: TABNAME => 'MLOG$_PJI_AV_ORG_F',
4963: PERCENT => 10,
4964: DEGREE => l_p_degree);

Line 4975: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

4971:
4972: END IF;
4973:
4974: if (l_extraction_type <> 'INCREMENTAL') then
4975: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
4976: tabname => 'PJI_AV_ORGO_F_MV',
4977: percent => 10,
4978: degree => l_p_degree);
4979: end if;

Line 5042: FND_STATS.GATHER_TABLE_STATS

5038: 'C',
5039: 'N');
5040: ELSE
5041:
5042: FND_STATS.GATHER_TABLE_STATS
5043: (OWNNAME => l_pji_schema,
5044: TABNAME => 'MLOG$_PJI_CA_ORG_F',
5045: PERCENT => 10,
5046: DEGREE => l_p_degree);

Line 5057: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

5053:
5054: END IF;
5055:
5056: if (l_extraction_type <> 'INCREMENTAL') then
5057: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5058: tabname => 'PJI_CA_ORGO_F_MV',
5059: percent => 10,
5060: degree => l_p_degree);
5061: end if;