APPS.FA_DEP_SUMM_TAX_REG_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 93: FROM fnd_segment_attribute_values fsav

89: SELECT fsav.application_column_name
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'

Line 117: FROM fnd_segment_attribute_values fsav

113: --To Fetch Column Name for segment 'Asset Type'
114: --*********************************************************
115: /*SELECT fsav.application_column_name
116: INTO gc_minor_category
117: FROM fnd_segment_attribute_values fsav
118: WHERE segment_attribute_type = 'MINOR_CATEGORY'
119: AND attribute_value = 'Y'
120: AND id_flex_code = 'CAT#';
121: */