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