APPS.JTF_DIAGNOSTIC_COREAPI dependencies on FND_FLEX_VALUE_RULES_VL

Line 826: from fnd_flex_value_rules_vl

822: end loop;
823:
824: if l_sec_enabled = 'Y' then
825: select count(*) into l_rule_count
826: from fnd_flex_value_rules_vl
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,

Line 830: from fnd_flex_value_rules_vl r,

826: from fnd_flex_value_rules_vl
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:

Line 3043: from fnd_flex_value_rules_vl

3039: end loop;
3040:
3041: if l_sec_enabled = 'Y' then
3042: select count(*) into l_rule_count
3043: from fnd_flex_value_rules_vl
3044: where flex_value_set_id = seg.value_set_id;
3045:
3046: select count(*) into l_rule_assign_count
3047: from fnd_flex_value_rules_vl r,

Line 3047: from fnd_flex_value_rules_vl r,

3043: from fnd_flex_value_rules_vl
3044: where flex_value_set_id = seg.value_set_id;
3045:
3046: select count(*) into l_rule_assign_count
3047: from fnd_flex_value_rules_vl r,
3048: fnd_flex_value_rule_usages ru
3049: where r.flex_value_rule_id = ru.flex_value_rule_id
3050: and r.flex_value_set_id = seg.value_set_id;
3051: