APPS.XLA_REPORT_UTILITY_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 190: l_display_flag fnd_id_flex_segments.display_flag%TYPE;

186:
187: l_flex_value_set_id NUMBER(10) ;
188: l_validation_type CHAR(1) ;
189: l_parent_segment VARCHAR2(80);
190: l_display_flag fnd_id_flex_segments.display_flag%TYPE;
191:
192: /**********************************************************************/
193: /* Following values for VALIDATION TYPE of a Value Set */
194: /* i) F : TABLE VALIDATED VALUE SET */

Line 207: FROM fnd_id_flex_segments

203:
204: -- Query to get the parent SEGMENT for Dependent Value Set : bug:7641746
205: CURSOR c_parent_segment_name(p_flex_value_set_id IN NUMBER) IS
206: SELECT application_column_name
207: FROM fnd_id_flex_segments
208: WHERE id_flex_code = 'GL#'
209: AND id_flex_num = p_coa_id
210: AND application_id = 101
211: AND flex_value_set_id =

Line 227: FROM fnd_id_flex_segments fid

223: p_segment_code VARCHAR2
224: )
225: IS
226: SELECT display_flag
227: FROM fnd_id_flex_segments fid
228: WHERE application_id = p_application_id
229: AND id_flex_code = p_id_flex_code
230: AND id_flex_num = p_id_flex_num
231: AND application_column_name = p_segment_code;

Line 2150: FROM fnd_id_flex_segments

2146: l_log_module VARCHAR2(240);
2147:
2148: CURSOR c(p_coa_id NUMBER,p_table_alias VARCHAR2) IS
2149: SELECT p_table_alias||'.'||application_column_name seg
2150: FROM fnd_id_flex_segments
2151: WHERE application_id =101
2152: AND id_flex_code ='GL#'
2153: AND id_flex_num = p_coa_id
2154: ORDER BY segment_num ;