32: BEGIN
33:
34: SELECT fvt.application_table_name INTO l_tab_name
35: FROM fnd_flex_validation_tables fvt,
36: fnd_flex_value_sets fvs
37: WHERE fvs.flex_value_set_id = X_vs_id
38: AND fvs.validation_type = 'F'
39: AND fvt.flex_value_set_id = fvs.flex_value_set_id;
40: EXCEPTION
64: FII_MESSAGE.Func_Ent (func_name => 'Get_Value_Set_Name');
65: end if;
66:
67: select flex_value_set_name into l_vs_name
68: from fnd_flex_value_sets
69: where flex_value_set_id = p_vs_id;
70:
71: if FIIDIM_Debug then
72: FII_MESSAGE.Func_Succ (func_name => 'Get_Value_Set_Name');