APPS.AME_MAN_ATTRIBUTES_API dependencies on AME_ATTRIBUTES

Line 31: from AME_ATTRIBUTES

27: (
28: X_ATTRIBUTE_NAME in VARCHAR2
29: ) is
30: select ATTRIBUTE_ID
31: from AME_ATTRIBUTES
32: where NAME = X_ATTRIBUTE_NAME
33: and sysdate between START_DATE
34: and nvl(END_DATE - (1/86400), sysdate);
35:

Line 223: X_LINE_ATTRIBUTE_NAME ame_attributes.name%type := null;

219: X_CURRENT_LAST_UPDATE_DATE VARCHAR2(19);
220: X_CURRENT_OWNER NUMBER;
221: X_LAST_UPDATED_BY NUMBER;
222: X_LAST_UPDATE_LOGIN NUMBER;
223: X_LINE_ATTRIBUTE_NAME ame_attributes.name%type := null;
224: X_CURRENT_OVN NUMBER;
225: begin
226: --detect if ame full patch has been applied
227: X_AME_INSTALLATION_LEVEL:=fnd_profile.value('AME_INSTALLATION_LEVEL');