DBA Data[Home] [Help]

APPS.JTF_DIAGNOSTIC_COREAPI dependencies on FND_FLEX_VALUE_RULE_USAGES

Line 831: fnd_flex_value_rule_usages ru

827: where flex_value_set_id = seg.value_set_id;
828:
829: select count(*) into l_rule_assign_count
830: from fnd_flex_value_rules_vl r,
831: fnd_flex_value_rule_usages ru
832: where r.flex_value_rule_id = ru.flex_value_rule_id
833: and r.flex_value_set_id = seg.value_set_id;
834:
835: Tab3Print('Security is enabled for this segment and value set with '||

Line 3044: fnd_flex_value_rule_usages ru

3040: where flex_value_set_id = seg.value_set_id;
3041:
3042: select count(*) into l_rule_assign_count
3043: from fnd_flex_value_rules_vl r,
3044: fnd_flex_value_rule_usages ru
3045: where r.flex_value_rule_id = ru.flex_value_rule_id
3046: and r.flex_value_set_id = seg.value_set_id;
3047:
3048: Tab2Print('Security is enabled for this segment and value set');