90: ,fifs.flex_value_set_id
91: INTO gc_major_category
92: ,gn_maj_cat_value_set_id
93: FROM fnd_segment_attribute_values fsav
94: ,fnd_id_flex_segments fifs
95: WHERE fifs.segment_name = 'Tax Group'
96: --fsav.segment_attribute_type = 'BASED_CATEGORY'
97: AND fsav.attribute_value = 'Y'
98: AND fsav.id_flex_code = 'CAT#'
121: */
122: BEGIN
123: SELECT fifs.application_column_name
124: INTO gc_minor_category
125: FROM fnd_id_flex_segments fifs
126: WHERE fifs.segment_name = 'Asset Type'
127: AND fifs.id_flex_num = 101
128: AND fifs.id_flex_code = 'CAT#';
129: EXCEPTION