DBA Data[Home] [Help]

APPS.GL_SECURITY_PKG dependencies on FND_FLEX_VALUE_RULE_LINES

Line 198: FROM fnd_flex_value_rule_lines

194:
195: CURSOR in_range_cur(rule_id number) IS
196: SELECT low,high from
197: (SELECT flex_value_low low,flex_value_high high
198: FROM fnd_flex_value_rule_lines
199: WHERE flex_value_rule_id = rule_id
200: AND include_exclude_indicator = 'I'
201: UNION
202: SELECT h1.child_flex_value_low low,h1.child_flex_value_high high

Line 203: FROM fnd_flex_value_rule_lines l,

199: WHERE flex_value_rule_id = rule_id
200: AND include_exclude_indicator = 'I'
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'

Line 222: FROM fnd_flex_value_rule_lines

218:
219: CURSOR ex_range_cur(rule_id number) IS
220: SELECT low,high from
221: (SELECT flex_value_low low,flex_value_high high
222: FROM fnd_flex_value_rule_lines
223: WHERE flex_value_rule_id = rule_id
224: AND include_exclude_indicator <> 'I'
225: UNION
226: SELECT h1.child_flex_value_low low,h1.child_flex_value_high high

Line 227: FROM fnd_flex_value_rule_lines l,

223: WHERE flex_value_rule_id = rule_id
224: AND include_exclude_indicator <> 'I'
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'