DBA Data[Home] [Help]

APPS.FEM_ADMIN_UTIL_PKG dependencies on FEM_XDIM_DIMENSIONS_VL

Line 1178: FROM fem_xdim_dimensions_vl

1174: v_surrogate_key_flag := '';
1175: IF col.fem_data_type_code = 'DIMENSION' THEN
1176: SELECT member_b_table_name, member_col, member_display_code_col, dimension_varchar_label
1177: INTO v_dim_mbr_table, v_dim_mbr_col, v_dim_mbr_dc_col, v_dim_label
1178: FROM fem_xdim_dimensions_vl
1179: WHERE dimension_id = col.dimension_id;
1180:
1181: IF v_dim_mbr_col = v_dim_mbr_dc_col THEN
1182: v_surrogate_key_flag := 'N';

Line 2090: FROM fem_xdim_dimensions_vl

2086: -- dimension
2087: FOR col IN c_dimcol (p_tab_name) LOOP
2088: SELECT count(*)
2089: INTO v_count
2090: FROM fem_xdim_dimensions_vl
2091: WHERE dimension_id = col.dimension_id
2092: AND value_set_required_flag = 'Y'
2093: AND dimension_varchar_label not in ('COMPANY','COST_CENTER');
2094: