DBA Data[Home] [Help]

APPS.FV_SLA_UTL_PROCESSING_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 247: FROM fnd_segment_attribute_values a,

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

Line 523: FROM fnd_segment_attribute_values a,

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

Line 561: FROM fnd_segment_attribute_values a,

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