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;
41: EXCEPTION
65: FII_MESSAGE.Func_Ent (func_name => 'Get_Value_Set_Name');
66: end if;
67:
68: select flex_value_set_name into l_vs_name
69: from fnd_flex_value_sets
70: where flex_value_set_id = p_vs_id;
71:
72: if FIIDIM_Debug then
73: FII_MESSAGE.Func_Succ (func_name => 'Get_Value_Set_Name');