[Home] [Help]
30: -- Execute statement to determine if the value set is table validated
31: BEGIN
32:
33: SELECT fvt.application_table_name INTO l_tab_name
34: FROM fnd_flex_validation_tables fvt,
35: fnd_flex_value_sets fvs
36: WHERE fvs.flex_value_set_id = X_vs_id
37: AND fvs.validation_type = 'F'
38: AND fvt.flex_value_set_id = fvs.flex_value_set_id;