647: l_seg_desc_join :=
648: REPLACE
649: (l_seg_desc_join
650: ,'$flex_value_set_id$'
651: ,xla_flex_pkg.get_segment_valueset
652: (p_application_id => 101
653: ,p_id_flex_code => 'GL#'
654: ,p_id_flex_num => l_coa_id
655: ,p_segment_code => l_balancing_segment
674: l_seg_desc_join :=
675: REPLACE
676: (l_seg_desc_join
677: ,'$flex_value_set_id$'
678: ,xla_flex_pkg.get_segment_valueset
679: (p_application_id => 101
680: ,p_id_flex_code => 'GL#'
681: ,p_id_flex_num => l_coa_id
682: ,p_segment_code => l_account_segment
700: l_seg_desc_join :=
701: REPLACE
702: (l_seg_desc_join
703: ,'$flex_value_set_id$'
704: ,xla_flex_pkg.get_segment_valueset
705: (p_application_id => 101
706: ,p_id_flex_code => 'GL#'
707: ,p_id_flex_num => l_coa_id
708: ,p_segment_code => l_costcenter_segment
727: l_seg_desc_join :=
728: REPLACE
729: (l_seg_desc_join
730: ,'$flex_value_set_id$'
731: ,xla_flex_pkg.get_segment_valueset
732: (p_application_id => 101
733: ,p_id_flex_code => 'GL#'
734: ,p_id_flex_num => l_coa_id
735: ,p_segment_code => l_management_segment
754: l_seg_desc_join :=
755: REPLACE
756: (l_seg_desc_join
757: ,'$flex_value_set_id$'
758: ,xla_flex_pkg.get_segment_valueset
759: (p_application_id => 101
760: ,p_id_flex_code => 'GL#'
761: ,p_id_flex_num => l_coa_id
762: ,p_segment_code => l_intercompany_segment