APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_HIER_DEFINITIONS

Line 1601: v_hier_flattened FEM_HIER_DEFINITIONS.

1597: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
1598: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_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;

Line 1649: FROM fem_hier_definitions d, fem_object_definition_b o,

1645: SELECT h.dimension_id, h.hierarchy_obj_id, a.object_name, od.display_name,
1646: h.flattened_rows_flag
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

Line 1689: FROM fem_hier_definitions

1685: END IF;
1686:
1687: SELECT flattened_rows_completion_code
1688: INTO v_hier_flattened
1689: FROM fem_hier_definitions
1690: WHERE hierarchy_obj_def_id = p_obj_def_id;
1691:
1692: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1693: FEM_ENGINES_PKG.TECH_MESSAGE(