APPS.GCS_XML_DT_UTILITY_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 503: ' fem_xdim_dimensions fxd, '||

499: ' FROM fem_cctr_orgs_hier fcoh, '||
500: ' fem_global_vs_combo_defs fgvscd_master, '||
501: ' gcs_system_options gso, '||
502: ' fem_global_vs_combo_defs fgvscd_child, '||
503: ' fem_xdim_dimensions fxd, '||
504: ' fem_object_definition_b fodb, '||
505: ' gcs_entity_cctr_orgs feco '||
506: ' WHERE fcoh.child_id = fb.company_cost_center_org_id '||
507: ' AND fxd.dimension_id = 8 '||

Line 824: FROM fem_xdim_dimensions

820:
821: -- Get the object_def_id with care for end date
822: SELECT NVL(default_mvs_hierarchy_obj_id,-1)
823: INTO l_def_hier_id
824: FROM fem_xdim_dimensions
825: WHERE dimension_id = 8;
826:
827: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
828: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_def_hier_id : '||l_def_hier_id);