APPS.AME_RULES_API2 dependencies on DUAL

Line 293: select ame_rules_s.nextval into X_RULE_ID from dual;

289:
290: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_RULES.'||X_RULE_KEY,lockhandle => lockHandle);
291: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0, release_on_commit=>true);
292: if returnValue = 0 then
293: select ame_rules_s.nextval into X_RULE_ID from dual;
294: insert into AME_RULES
295: (
296: RULE_ID,
297: RULE_KEY,

Line 325: from sys.dual

321: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
322: X_DESCRIPTION,
323: X_ITEM_CLASS_ID,
324: X_OBJECT_VERSION_NUMBER
325: from sys.dual
326: where not exists (select NULL
327: from AME_RULES
328: where RULE_KEY = X_RULE_KEY
329: and sysdate between START_DATE

Line 416: from sys.dual

412: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
413: X_DESCRIPTION,
414: X_ITEM_CLASS_ID,
415: X_OBJECT_VERSION_NUMBER
416: from sys.dual
417: where not exists (select NULL
418: from AME_RULES
419: where RULE_ID = X_RULE_ID
420: and ((START_DATE - (1/86400)) <= sysdate)