APPS.AME_ATU_BUS dependencies on FND_FLEX_VALUE_SETS

Line 253: from fnd_flex_value_sets

249: l_proc varchar2(72) := g_package||'chk_value_set_id';
250: begin
251: if p_value_set_id is not null then
252: select count(*) into l_count
253: from fnd_flex_value_sets
254: where flex_value_set_id = p_value_set_id and
255: instr(flex_value_set_name,'$') = 0 ;
256: if l_count = 0 then
257: fnd_message.set_name('PER','AME_400553_VAL_SET_ID_NOT_EX');

Line 303: from fnd_flex_value_sets

299: fnd_message.raise_error;
300: end if;
301: elsif p_value_set_id is not null then
302: select format_type into l_format_type
303: from fnd_flex_value_sets
304: where flex_value_set_id = p_value_set_id and
305: instr(flex_value_set_name,'$') = 0 ;
306:
307: if ((l_attribute_type = ame_util.currencyAttributeType)