APPS.PON_FORMS_JRAD_PVT dependencies on FND_FLEX_VALUE_SETS

Line 68: select decode(fnd_flex_value_sets.longlist_flag, 'X', 'N', 'Y') isLov

64:
65: v_ret_value := 'N';
66:
67: BEGIN
68: select decode(fnd_flex_value_sets.longlist_flag, 'X', 'N', 'Y') isLov
69: into v_ret_value
70: from pon_fields,
71: fnd_flex_value_sets
72: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name

Line 71: fnd_flex_value_sets

67: BEGIN
68: select decode(fnd_flex_value_sets.longlist_flag, 'X', 'N', 'Y') isLov
69: into v_ret_value
70: from pon_fields,
71: fnd_flex_value_sets
72: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name
73: and pon_fields.value_set_name is not null
74: and pon_fields.field_code = p_field_code;
75:

Line 72: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name

68: select decode(fnd_flex_value_sets.longlist_flag, 'X', 'N', 'Y') isLov
69: into v_ret_value
70: from pon_fields,
71: fnd_flex_value_sets
72: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name
73: and pon_fields.value_set_name is not null
74: and pon_fields.field_code = p_field_code;
75:
76: EXCEPTION

Line 569: SELECT fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE

565: || p_mapping_field || ' ' || p_value_set_name);
566:
567: BEGIN
568:
569: SELECT fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE
570: INTO v_display_type, v_validation_type
571: FROM fnd_flex_value_sets
572: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;
573:

Line 571: FROM fnd_flex_value_sets

567: BEGIN
568:
569: SELECT fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE
570: INTO v_display_type, v_validation_type
571: FROM fnd_flex_value_sets
572: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;
573:
574: EXCEPTION
575: WHEN OTHERS THEN

Line 572: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;

568:
569: SELECT fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE
570: INTO v_display_type, v_validation_type
571: FROM fnd_flex_value_sets
572: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;
573:
574: EXCEPTION
575: WHEN OTHERS THEN
576: RAISE FND_FLEX_EXCEPTION;