DBA Data[Home] [Help]

APPS.AME_ATTRIBUTES_API dependencies on DUAL

Line 160: from dual;

156:
157: if X_RETURN_VALUE = 0 then
158: select AME_ATTRIBUTES_S.NEXTVAL
159: into X_ATTRIBUTE_ID
160: from dual;
161:
162: insert into AME_ATTRIBUTES
163: (ATTRIBUTE_ID
164: ,NAME

Line 193: from dual where not exists (select null

189: X_LAST_UPDATE_LOGIN,
190: X_START_DATE,
191: X_END_DATE,
192: X_OBJECT_VERSION_NUMBER
193: from dual where not exists (select null
194: from AME_ATTRIBUTES
195: where NAME = X_ATTRIBUTE_NAME
196: and sysdate between START_DATE and nvl(END_DATE - (1/86400), sysdate));
197: