eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_RULES_API dependencies on DUAL

Line 192: from sys.dual

188: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
189: X_DESCRIPTION,
190: X_ITEM_CLASS_ID,
191: X_OBJECT_VERSION_NUMBER
192: from sys.dual
193: where not exists (select NULL
194: from AME_RULES
195: where ((RULE_ID = X_RULE_ID
196: and sysdate < nvl(END_DATE - (1/86400), sysdate + (1/86400)))

Line 285: from sys.dual

281: X_LAST_UPDATE_LOGIN,
282: X_START_DATE,
283: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
284: X_OBJECT_VERSION_NUMBER
285: from sys.dual
286: where not exists (select NULL
287: from AME_ACTION_USAGES
288: where RULE_ID = X_RULE_ID
289: and ACTION_ID = X_ACTION_ID

Line 337: select AME_RULE_KEYS_S.NEXTVAL into X_RULE_KEY_ID from dual;

333: end if;
334: close GET_DBID_CURSOR;
335: loop
336: -- derive RULE_KEY value
337: select AME_RULE_KEYS_S.NEXTVAL into X_RULE_KEY_ID from dual;
338: X_NEW_RULE_KEY := X_DATABASE_ID ||':'|| X_RULE_KEY_ID;
339: select count(*)
340: into X_RULE_COUNT
341: from AME_RULES