APPS.GL_SUMMARY_ACCOUNT_TYPES_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 56: fnd_id_flex_segments seg,

52: INTO acct_segcol, acct_vsetid, acct_pvsetid,
53: acct_tname, acct_vcolname, acct_attrib
54: FROM fnd_flex_validation_tables vt,
55: fnd_flex_value_sets vs,
56: fnd_id_flex_segments seg,
57: fnd_segment_attribute_values qual
58: WHERE qual.application_id = 101
59: AND qual.id_flex_code = 'GL#'
60: AND qual.id_flex_num = coa_id

Line 73: FROM fnd_id_flex_segments pseg

69:
70: IF (acct_pvsetid IS NOT NULL) THEN
71: SELECT application_column_name
72: INTO acct_psegcol
73: FROM fnd_id_flex_segments pseg
74: WHERE application_id = 101
75: AND id_flex_code = 'GL#'
76: AND id_flex_num = coa_id
77: AND flex_value_set_id+0 = acct_pvsetid

Line 79: FROM fnd_id_flex_segments pseg2

75: AND id_flex_code = 'GL#'
76: AND id_flex_num = coa_id
77: AND flex_value_set_id+0 = acct_pvsetid
78: AND segment_num = (SELECT min(segment_num)
79: FROM fnd_id_flex_segments pseg2
80: WHERE application_id = 101
81: AND id_flex_code = 'GL#'
82: AND id_flex_num = coa_id
83: AND flex_value_set_id+0 = acct_pvsetid);