APPS.GL_FLEX_INSERT_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 267: /* FND_SEGMENT_ATTRIBUTE_VALUES */

263: /* */
264: /* AOL Tables which are being used include : */
265: /* */
266: /* FND_ID_FLEX_SEGMENTS */
267: /* FND_SEGMENT_ATTRIBUTE_VALUES */
268: /* FND_FLEX_HIERARCHIES */
269: /* FND_FLEX_VALUE_HIERARCHIES */
270: /* FND_FLEX_VALUES */
271: /* FND_SEG_RPT_ATTRIBUTES */

Line 1126: select /*+ ORDERED INDEX (FND_SEGMENT_ATTRIBUTE_VALUES

1122:
1123: cursor accseg(flex_num NUMBER,
1124: appl_id NUMBER,
1125: flex_code VARCHAR2) IS
1126: select /*+ ORDERED INDEX (FND_SEGMENT_ATTRIBUTE_VALUES
1127: FND_SEGMENT_ATTRIBUTE_VALS_U1) */
1128: application_column_name
1129: from fnd_segment_attribute_values
1130: where attribute_value = 'Y'

Line 1129: from fnd_segment_attribute_values

1125: flex_code VARCHAR2) IS
1126: select /*+ ORDERED INDEX (FND_SEGMENT_ATTRIBUTE_VALUES
1127: FND_SEGMENT_ATTRIBUTE_VALS_U1) */
1128: application_column_name
1129: from fnd_segment_attribute_values
1130: where attribute_value = 'Y'
1131: and segment_attribute_type = 'GL_ACCOUNT'
1132: and id_flex_num = flex_num
1133: and application_id = appl_id