APPS.FEM_DIS_HIER_PKG dependencies on FEM_LOOKUPS

Line 313: v_dummy_parent_name FEM_LOOKUPS.MEANING%TYPE;

309: v_hierarchy_table_name FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE;
310: v_attribute_table_name FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE;
311: v_composite_dimension_flag FEM_XDIM_DIMENSIONS.COMPOSITE_DIMENSION_FLAG%TYPE;
312: v_value_set_required_flag FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE;
313: v_dummy_parent_name FEM_LOOKUPS.MEANING%TYPE;
314:
315: v_dis_hierarchy_table_name VARCHAR2(30);
316: v_dis_hierarchy_table_name_b VARCHAR2(30);
317: v_dis_hierarchy_table_name_tl VARCHAR2(30);

Line 479: FROM FEM_LOOKUPS

475: *************************************************************************/
476: BEGIN
477: SELECT MEANING
478: INTO v_dummy_parent_name
479: FROM FEM_LOOKUPS
480: WHERE LOOKUP_TYPE = 'FEM_DIS_DUMMY_PARENT'
481: AND LOOKUP_CODE = 'DUMMY_PARENT_NAME';
482: EXCEPTION
483: WHEN NO_DATA_FOUND THEN