APPS.PER_OPL_ORGH dependencies on PER_ORG_HRCHY_SUMMARY

Line 121: INSERT INTO /*+ PARALLEL(, DEFAULT, DEFAULT) */ PER_org_hrchy_summary

117:
118: -- Trap unique constraint errors
119: BEGIN
120:
121: INSERT INTO /*+ PARALLEL(

, DEFAULT, DEFAULT) */ PER_org_hrchy_summary
122: (organization_structure_id
123: ,org_structure_version_id
124: ,org_business_group_id
125: ,organization_id

Line 174: INSERT INTO /*+ PARALLEL(

, DEFAULT, DEFAULT) */ PER_org_hrchy_summary

170:
171: BEGIN
172: -- insert chunk of rows
173: FORALL i IN 1..g_cs_rows_to_insert
174: INSERT INTO /*+ PARALLEL(

, DEFAULT, DEFAULT) */ PER_org_hrchy_summary
175: (organization_structure_id
176: ,org_structure_version_id
177: ,org_business_group_id
178: ,organization_id

Line 461: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.PER_ORG_HRCHY_SUMMARY';

457: /* Get PER schema name - get_app_info populates l_schema */
458: IF fnd_installation.get_app_info('PER',l_dummy1, l_dummy2, l_schema) THEN
459:
460: /* Empty out organization hierarchy tables */
461: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.PER_ORG_HRCHY_SUMMARY';
462: EXECUTE IMMEDIATE(l_sql_stmt);
463:
464: /* Write timing information to log */
465: output('Truncated organization Hierarchy tables: ' ||