42: l_application_column_name VARCHAR2(30);
43: l_seg_num NUMBER;
44:
45: /* Defined the cursor seg_cursor to fix bug 2981493 */
46: CURSOR seg_cursor (l_coa_id fnd_segment_attribute_values.id_flex_num%type,
47: l_segment fnd_segment_attribute_values.segment_attribute_type%type) IS
48: SELECT segment_num
49: FROM fnd_segment_attribute_values fsav, fnd_id_flex_segments fifs
50: WHERE fsav.application_id = 101
43: l_seg_num NUMBER;
44:
45: /* Defined the cursor seg_cursor to fix bug 2981493 */
46: CURSOR seg_cursor (l_coa_id fnd_segment_attribute_values.id_flex_num%type,
47: l_segment fnd_segment_attribute_values.segment_attribute_type%type) IS
48: SELECT segment_num
49: FROM fnd_segment_attribute_values fsav, fnd_id_flex_segments fifs
50: WHERE fsav.application_id = 101
51: AND fsav.id_flex_code = 'GL#'
45: /* Defined the cursor seg_cursor to fix bug 2981493 */
46: CURSOR seg_cursor (l_coa_id fnd_segment_attribute_values.id_flex_num%type,
47: l_segment fnd_segment_attribute_values.segment_attribute_type%type) IS
48: SELECT segment_num
49: FROM fnd_segment_attribute_values fsav, fnd_id_flex_segments fifs
50: WHERE fsav.application_id = 101
51: AND fsav.id_flex_code = 'GL#'
52: AND fsav.id_flex_num = l_coa_id
53: AND fsav.segment_attribute_type = l_segment