APPS.FA_ASSET_SUMM_RPT_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 843: FROM fnd_segment_attribute_values fsav

839: --dynamically
840: --*************************************************
841: SELECT fsav.application_column_name
842: INTO lc_maj_seg
843: FROM fnd_segment_attribute_values fsav
844: WHERE fsav.id_flex_code = 'CAT#'
845: AND fsav.id_flex_num = gc_cat_flex_struc
846: AND fsav.attribute_value = 'Y'
847: AND fsav.segment_attribute_type = 'BASED_CATEGORY';

Line 851: FROM fnd_segment_attribute_values fsav

847: AND fsav.segment_attribute_type = 'BASED_CATEGORY';
848:
849: SELECT fsav.application_column_name
850: INTO lc_min_seg
851: FROM fnd_segment_attribute_values fsav
852: WHERE fsav.id_flex_code = 'CAT#'
853: AND fsav.id_flex_num = gc_cat_flex_struc
854: AND fsav.attribute_value = 'Y'
855: AND fsav.segment_attribute_type = 'MINOR_CATEGORY';