APPS.OKC_XPRT_UTIL_PVT dependencies on FND_FLEX_VALUE_SETS

Line 458: FROM fnd_flex_value_sets

454: ) RETURN NUMBER IS
455:
456: CURSOR csr_value_set_id IS
457: SELECT flex_value_set_id
458: FROM fnd_flex_value_sets
459: WHERE flex_value_set_name = p_value_set_name;
460:
461: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
462:

Line 461: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;

457: SELECT flex_value_set_id
458: FROM fnd_flex_value_sets
459: WHERE flex_value_set_name = p_value_set_name;
460:
461: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
462:
463: BEGIN
464:
465: OPEN csr_value_set_id;

Line 5484: fnd_flex_value_sets fvs

5480: fvs.flex_value_set_id OBJECT_VALUE_SET_ID,
5481: fvs.validation_type,
5482: fvs.longlist_flag
5483: FROM OKC_XPRT_RULE_CONDITIONS RuleCond,
5484: fnd_flex_value_sets fvs
5485: where rtrim(RuleCond.OBJECT_VALUE_SET_NAME) = fvs.flex_value_set_name(+)
5486: and rule_condition_id=p_rule_condition_id;
5487:
5488: l_value VARCHAR2(1000) := null;

Line 5534: fnd_flex_value_sets fvs

5530: fvs.flex_value_set_id OBJECT_VALUE_SET_ID,
5531: fvs.validation_type,
5532: fvs.longlist_flag
5533: FROM OKC_XPRT_RULE_CONDITIONS RuleCond,
5534: fnd_flex_value_sets fvs
5535: where RuleCond.OBJECT_VALUE_SET_NAME = fvs.flex_value_set_name(+)
5536: and rule_condition_id=p_rule_condition_id;
5537:
5538: l_value VARCHAR2(1000) := null;