1996: -- Region is stored in a flex segment and mapped using flex wizard
1997: cursor region_csr is
1998: select bfm.application_column_name
1999: from bis_flex_mappings_v bfm 2000: , bis_dimensions bd 2001: where bfm.dimension_id = bd.dimension_id
2002: and bd.short_name = 'GEOGRAPHY'
2003: and bfm.level_short_name = 'REGION'
2004: and bfm.application_id = 800;