APPS.GCS_IC_LOB_ELIM_PARENT_PKG dependencies on FEM_USER_DIM1_HIER_T

Line 421: ||' into fem_user_dim1_hier_T ');

417: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: fnd_log.STRING(fnd_log.level_procedure,
419: g_pkg_name || '.' || l_api_name,
420: 'Insert existing hierarchy members '
421: ||' into fem_user_dim1_hier_T ');
422: END IF;
423:
424: INSERT INTO fem_user_dim1_hier_t
425: (hierarchy_object_name,

Line 424: INSERT INTO fem_user_dim1_hier_t

420: 'Insert existing hierarchy members '
421: ||' into fem_user_dim1_hier_T ');
422: END IF;
423:
424: INSERT INTO fem_user_dim1_hier_t
425: (hierarchy_object_name,
426: hierarchy_obj_def_display_name,
427: parent_display_code,
428: parent_value_set_display_code,

Line 462: INSERT INTO fem_user_dim1_hier_t

458:
459: l_submit_req := SQL%ROWCOUNT;
460: g_no_rows := NVL(SQL%ROWCOUNT,0);
461:
462: INSERT INTO fem_user_dim1_hier_t
463: (hierarchy_object_name,
464: hierarchy_obj_def_display_name,
465: parent_display_code,
466: parent_value_set_display_code,

Line 482: FROM fem_user_dim1_hier_t fudh

478: l_vs_display_code ,
479: 1,
480: 'LOAD',
481: USERENV('LANG')
482: FROM fem_user_dim1_hier_t fudh
483: WHERE fudh.hierarchy_object_name = p_hierarchy_name
484: AND fudh.hierarchy_obj_def_display_name = p_version_name
485: AND fudh.parent_display_code <> fudh.child_display_code
486: AND fudh.parent_value_set_display_code = fudh.child_value_set_display_code;