DBA Data[Home] [Help]

APPS.FA_DEP_SUMM_TAX_REG_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 94: ,fnd_id_flex_segments fifs

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#'

Line 125: FROM fnd_id_flex_segments fifs

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