APPS.AME_ATR_BUS dependencies on AME_CONDITIONS

Line 392: from ame_conditions

388: --
389: --
390: Cursor C_Sel3 is
391: select count(*)
392: from ame_conditions
393: where attribute_id = p_attribute_id
394: and p_start_date between start_date and
395: nvl(end_date - ame_util.oneSecond, p_start_date) ;
396: --

Line 421: -- ame_conditions

417: fnd_message.set_name('AME','AME_400170_ATT_MAND_CANT_DEL');
418: fnd_message.set_token('TABLE_NAME','ame_mandatory_attributes');
419: hr_multi_message.add;
420: End If;
421: -- ame_conditions
422: Open C_Sel3;
423: Fetch C_Sel3 into l_child_count;
424: Close C_Sel3;
425: If l_child_count >0 then

Line 427: fnd_message.set_token('TABLE_NAME','ame_conditions');

423: Fetch C_Sel3 into l_child_count;
424: Close C_Sel3;
425: If l_child_count >0 then
426: fnd_message.set_name('AME','AME_400524_ATT_COND_EXIST');
427: fnd_message.set_token('TABLE_NAME','ame_conditions');
428: hr_multi_message.add;
429: End If;
430: --
431: End chk_usages_exist;