DBA Data[Home] [Help]

APPS.GL_SECURITY_PKG dependencies on FND_FLEX_VALUE_SETS

Line 180: FROM FND_FLEX_VALUE_SETS vs, FND_ID_FLEX_SEGMENTS sg

176: SELECT sg.application_column_name,
177: sg.flex_value_set_id,
178: sg.segment_num,
179: vs.validation_type
180: FROM FND_FLEX_VALUE_SETS vs, FND_ID_FLEX_SEGMENTS sg
181: WHERE sg.application_id = 101
182: AND sg.id_flex_code = 'GL#'
183: AND sg.id_flex_num = coa_id
184: AND sg.security_enabled_flag = 'Y'

Line 205: fnd_flex_value_sets fv

201: UNION
202: SELECT h1.child_flex_value_low low,h1.child_flex_value_high high
203: FROM fnd_flex_value_rule_lines l,
204: fnd_flex_value_hier_all h1,
205: fnd_flex_value_sets fv
206: WHERE l.flex_value_rule_id = rule_id
207: AND l.include_exclude_indicator = 'I'
208: AND h1.flex_value_set_id = l.flex_value_set_id
209: AND h1.parent_flex_value BETWEEN l.flex_value_low AND l.flex_value_high

Line 229: fnd_flex_value_sets fv

225: UNION
226: SELECT h1.child_flex_value_low low,h1.child_flex_value_high high
227: FROM fnd_flex_value_rule_lines l,
228: fnd_flex_value_hier_all h1,
229: fnd_flex_value_sets fv
230: WHERE l.flex_value_rule_id = rule_id
231: AND l.include_exclude_indicator <> 'I'
232: AND h1.flex_value_set_id = l.flex_value_set_id
233: AND h1.parent_flex_value BETWEEN l.flex_value_low AND l.flex_value_high