APPS.FII_LOB_MAINTAIN_PKG dependencies on FND_FLEX_VALUE_SETS

Line 34: fnd_flex_value_sets fvs

30: BEGIN
31:
32: SELECT fvt.application_table_name INTO l_tab_name
33: FROM fnd_flex_validation_tables fvt,
34: fnd_flex_value_sets fvs
35: WHERE fvs.flex_value_set_id = X_vs_id
36: AND fvs.validation_type = 'F'
37: AND fvt.flex_value_set_id = fvs.flex_value_set_id;
38: EXCEPTION

Line 66: from fnd_flex_value_sets

62: -- FII_MESSAGE.Func_Ent (func_name => 'Get_Value_Set_Name');
63: -- end if;
64:
65: select flex_value_set_name into l_vs_name
66: from fnd_flex_value_sets
67: where flex_value_set_id = p_vs_id;
68:
69: -- if FIIDIM_Debug then
70: -- FII_MESSAGE.Func_Succ (func_name => 'Get_Value_Set_Name');

Line 237: from fnd_flex_value_sets

233: -- --------------------------------------------------------
234:
235: g_phase := 'Find the shipped FII value set id';
236: select FLEX_VALUE_SET_ID into G_FII_INT_VALUE_SET_ID
237: from fnd_flex_value_sets
238: where flex_value_set_name = 'Financials Intelligence Internal Value Set';
239:
240: g_phase := 'Find the unassigned LOB ID from value set: '||G_FII_INT_VALUE_SET_ID;
241: select flex_value_id into G_UNASSIGNED_LOB_ID