APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_HIERARCHIES

Line 1603: v_hier_obj_id FEM_HIERARCHIES.HIERARCHY_OBJ_ID%TYPE;

1599: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%TYPE;
1600: v_hier_table_name FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE;
1601: v_hier_flattened FEM_HIER_DEFINITIONS.
1602: FLATTENED_ROWS_COMPLETION_CODE%TYPE;
1603: v_hier_obj_id FEM_HIERARCHIES.HIERARCHY_OBJ_ID%TYPE;
1604: v_hier_obj_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
1605: v_hier_obj_def_name FEM_OBJECT_DEFINITION_VL.DISPLAY_NAME%TYPE;
1606: v_mbr_disp_cd_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
1607: v_value_set_name FEM_VALUE_SETS_VL.VALUE_SET_NAME%TYPE;

Line 1651: fem_object_catalog_b c, fem_hierarchies h, fem_object_catalog_vl a

1647: INTO v_dim_id, v_hier_obj_id, v_hier_obj_name, v_hier_obj_def_name,
1648: v_flat_flag
1649: FROM fem_hier_definitions d, fem_object_definition_b o,
1650: fem_object_definition_vl od,
1651: fem_object_catalog_b c, fem_hierarchies h, fem_object_catalog_vl a
1652: WHERE d.hierarchy_obj_def_id = p_obj_def_id
1653: AND d.hierarchy_obj_def_id = o.object_definition_id
1654: AND o.object_definition_id = od.object_definition_id
1655: AND o.object_id = c.object_id