APPS.MTH_SEED_DATA_PKG dependencies on MTH_DIM_HIERARCHY

Line 10: mth_util_pkg.log_msg('Inserting MTH_DIM_HIERARCHY ', mth_util_pkg.G_DBG_USER_INFO);

6:
7: BEGIN
8:
9: mth_util_pkg.log_msg('POPULATE_SEED_DATA start', mth_util_pkg.G_DBG_PROC_FUN_START);
10: mth_util_pkg.log_msg('Inserting MTH_DIM_HIERARCHY ', mth_util_pkg.G_DBG_USER_INFO);
11:
12: merge INTO MTH_DIM_HIERARCHY t
13: USING
14: (

Line 12: merge INTO MTH_DIM_HIERARCHY t

8:
9: mth_util_pkg.log_msg('POPULATE_SEED_DATA start', mth_util_pkg.G_DBG_PROC_FUN_START);
10: mth_util_pkg.log_msg('Inserting MTH_DIM_HIERARCHY ', mth_util_pkg.G_DBG_USER_INFO);
11:
12: merge INTO MTH_DIM_HIERARCHY t
13: USING
14: (
15: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Resource Group Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_RG' HIER_INTERNAL_NAME, 3 NUMBER_OF_LEVEL FROM DUAL UNION ALL
16: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Department Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_DEPT' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL