APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_DIM_ATTRIBUTES_B

Line 208: FROM fem_datasets_attr dsa, fem_dim_attributes_b dma,

204: -- If not, get a production one. If none exist, raise unexp error.
205: BEGIN
206: SELECT io.dataset_io_obj_def_id
207: INTO v_ds_io_def_id
208: FROM fem_datasets_attr dsa, fem_dim_attributes_b dma,
209: fem_datasets_b d, fem_ds_input_output_defs io
210: WHERE io.output_dataset_code = d.dataset_code
211: AND dsa.DATASET_CODE = io.output_dataset_code
212: AND dma.attribute_id = dsa.attribute_id

Line 1098: FROM fem_dim_attributes_b a, fem_cond_dim_components c,

1094: --for each object definition id there can be several attributes referenced
1095: --all need to be checked to see if they reference disabled members.
1096: cursor c_attr_dim (p_obj_def_id IN NUMBER, p_param_dim_id IN NUMBER) IS
1097: SELECT a.attribute_dimension_id, d.criteria_sequence
1098: FROM fem_dim_attributes_b a, fem_cond_dim_components c,
1099: fem_cond_dim_cmp_dtl d, fem_xdim_dimensions x
1100: WHERE a.dimension_id = c.dim_id
1101: AND a.attribute_dimension_id = x.dimension_id
1102: AND x.hier_editor_managed_flag = 'Y'