243: -- Get the GL ACCOUNT segment num and name
244: BEGIN
245: SELECT b.segment_num
246: INTO l_accounting_seg_num
247: FROM fnd_segment_attribute_values a,
248: fnd_id_flex_segments b
249: WHERE a.application_id = b.application_id
250: AND a.id_flex_code = b.id_flex_code
251: AND a.id_flex_num = b.id_flex_num
519: SELECT b.segment_num,
520: b.application_column_name
521: INTO l_ledger_rec.accounting_seg_num,
522: l_ledger_rec.accounting_seg_name
523: FROM fnd_segment_attribute_values a,
524: fnd_id_flex_segments b
525: WHERE a.application_id = b.application_id
526: AND a.id_flex_code = b.id_flex_code
527: AND a.id_flex_num = b.id_flex_num
557: SELECT b.segment_num,
558: b.application_column_name
559: INTO l_ledger_rec.balancing_seg_num,
560: l_ledger_rec.balancing_seg_name
561: FROM fnd_segment_attribute_values a,
562: fnd_id_flex_segments b
563: WHERE a.application_id = b.application_id
564: AND a.id_flex_code = b.id_flex_code
565: AND a.id_flex_num = b.id_flex_num