210: segment_number => l_bal_segnum);
211: */
212: /* Bug 5246620. Wrong segment_number retrieved */
213: SELECT s.segment_num INTO l_bal_segnum
214: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
215: fnd_segment_attribute_types sat
216: WHERE s.application_id = 101
217: AND s.id_flex_code = 'GL#'
218: AND s.id_flex_num = l_account_flex
1211: segment_number => l_bal_segnum);
1212: */
1213: /* Bug 5246620. Wrong segment_number retrieved */
1214: SELECT s.segment_num INTO l_bal_segnum
1215: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
1216: fnd_segment_attribute_types sat
1217: WHERE s.application_id = 101
1218: AND s.id_flex_code = 'GL#'
1219: AND s.id_flex_num = l_account_flex
1566: segment_number => l_bal_segnum);
1567: */
1568: /* Bug 5246620. Wrong segment_number retrieved */
1569: SELECT s.segment_num INTO l_bal_segnum
1570: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
1571: fnd_segment_attribute_types sat
1572: WHERE s.application_id = 101
1573: AND s.id_flex_code = 'GL#'
1574: AND s.id_flex_num = l_account_flex