APPS.FEM_BI_DIMENSION_UTILS_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 1199: from fem_xdim_dimensions_vl

1195: ,l_group_use_code
1196: ,l_value_set_required_flag
1197: ,l_enabled_applicable_flag
1198: ,l_read_only_applicable_flag
1199: from fem_xdim_dimensions_vl
1200: where dimension_varchar_label = p_dimension_varchar_label;
1201:
1202: ----------------------------------------------------------------------------
1203: -- Initialize variables used in dynamic SQL based on dimension properties --

Line 2091: from fem_xdim_dimensions

2087: ,l_attr_mem_name_col
2088: ,l_attrd_value_set_where
2089: ,l_attrn_value_set_where
2090: ,l_attrn_language_where
2091: from fem_xdim_dimensions
2092: where dimension_id = attr_rec.attribute_dimension_id;
2093:
2094: l_attrd_sql_stmt :=
2095: ' select adb.'||l_attr_mem_display_code_col||

Line 2498: ' from fem_xdim_dimensions@'||p_seed_db_link||

2494: ' ,null)'||
2495: ' ,decode(member_tl_table_name'||
2496: ' ,member_vl_object_name,null'||
2497: ' ,'' and adtl.language = tl.language'')'||
2498: ' from fem_xdim_dimensions@'||p_seed_db_link||
2499: ' where dimension_id = :b_attribute_dimension_id'
2500: into l_attr_mem_b_tab
2501: ,l_attr_mem_tl_tab
2502: ,l_attr_mem_col