866: --dynamically
867: --*************************************************
868: SELECT fsav.application_column_name
869: INTO lc_maj_seg
870: FROM fnd_segment_attribute_values fsav
871: WHERE fsav.id_flex_code = 'CAT#'
872: AND fsav.id_flex_num = gc_cat_flex_struc
873: AND fsav.attribute_value = 'Y'
874: AND fsav.segment_attribute_type = 'BASED_CATEGORY';
874: AND fsav.segment_attribute_type = 'BASED_CATEGORY';
875:
876: SELECT fsav.application_column_name
877: INTO lc_min_seg
878: FROM fnd_segment_attribute_values fsav
879: WHERE fsav.id_flex_code = 'CAT#'
880: AND fsav.id_flex_num = gc_cat_flex_struc
881: AND fsav.attribute_value = 'Y'
882: AND fsav.segment_attribute_type = 'MINOR_CATEGORY';