APPS.FEM_FACTOR_TABLES_UTIL_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 301: select member_b_table_name,member_col into l_member_table_name,l_member_col from fem_xdim_dimensions where dimension_id = p_dimension_id;

297: x_valid_flag := 'Y';
298: return;
299: end if;
300:
301: select member_b_table_name,member_col into l_member_table_name,l_member_col from fem_xdim_dimensions where dimension_id = p_dimension_id;
302: l_query := 'select ''Y'' from ' || l_member_table_name ||
303: ' WHERE DIMENSION_GROUP_ID IN (SELECT DIMENSION_GROUP_ID FROM FEM_HIER_DIMENSION_GRPS WHERE HIERARCHY_OBJ_ID = ' || p_hier_object_id ||
304: ') AND DIMENSION_GROUP_ID = ' || p_group_id ||
305: ' AND ' || l_member_col || ' = ' || p_member_id ;