SELECT fnd_flex_values_vl.flex_value,

fnd_flex_values_vl.flex_value VALUE,

fnd_flex_values_vl.description DESCRIPTION,

nvl(fnd_flex_values_vl.summary_flag, 'N'),

nvl(to_number(fnd_flex_values_vl.structured_hierarchy_level), -1),

fnd_flex_values_vl.compiled_value_attributes,

nvl(fnd_flex_values_vl.enabled_flag, 'Y'),

nvl(to_char(fnd_flex_values_vl.start_date_active, 'J'), 0),

nvl(to_char(fnd_flex_values_vl.end_date_active, 'J'), 0)

FROM fnd_flex_values_vl fnd_flex_values_vl

WHERE (fnd_flex_values_vl.flex_value_set_id = 1013707)--p_flex_value_set_id

AND (((1 = 1) AND /*

gl_coa_bs_tag */

(gl_aff_awc_api_pkg.gl_valid_flex_values(SYSDATE,--p_date

fnd_flex_values_vl.flex_value) = 'Y')))

AND NOT EXISTS (SELECT NULL FROM fnd_flex_value_rule_lines l, fnd_flex_value_rule_usages u

WHERE u.application_id = 101--p_application_id

AND u.responsibility_id = 50726--p_responsibility_id

AND u.flex_value_set_id = 1013707--p_flex_value_set_id

AND l.flex_value_rule_id = u.flex_value_rule_id

AND l.include_exclude_indicator = 'E'

AND fnd_flex_values_vl.flex_value BETWEEN

nvl(decode(u.flex_value_set_id,

1013707,--p_flex_value_set_id

l.flex_value_low,

NULL),

fnd_flex_values_vl.flex_value) AND

nvl(decode(u.flex_value_set_id,

1013707,--p_flex_value_set_id

l.flex_value_high,

NULL),

fnd_flex_values_vl.flex_value))

AND NOT EXISTS (SELECT NULL FROM fnd_flex_value_rule_usages u

WHERE u.application_id = 101--p_application_id

AND u.responsibility_id = 50726--p_responsibility_id

AND u.flex_value_set_id = 1013707--p_flex_value_set_id

AND NOT EXISTS (SELECT NULL FROM fnd_flex_value_rule_lines l

WHERE l.flex_value_rule_id = u.flex_value_rule_id

AND l.include_exclude_indicator = 'I'

AND fnd_flex_values_vl.flex_value BETWEEN

nvl(decode(u.flex_value_set_id,

1013707,--p_flex_value_set_id

l.flex_value_low,

NULL),

fnd_flex_values_vl.flex_value) AND

nvl(decode(u.flex_value_set_id,

1013707,--p_flex_value_set_id

l.flex_value_high,

NULL),

fnd_flex_values_vl.flex_value)))

ORDER BY fnd_flex_values_vl.flex_value