APPS.AME_SEED_UTILITY dependencies on DUAL

Line 422: AME_UTIL.DUALCHAINSAUTHORITYTYPENAME, 9,

418: AME_UTIL.POSITIONLEVELTYPENAME, 5,
419: AME_UTIL.MANAGERFINALAPPROVERTYPENAME, 6,
420: AME_UTIL.FINALAPPROVERONLYTYPENAME, 7,
421: AME_UTIL.LINEITEMJOBLEVELTYPENAME, 8,
422: AME_UTIL.DUALCHAINSAUTHORITYTYPENAME, 9,
423: AME_UTIL.GROUPCHAINAPPROVALTYPENAME, 10,
424: AME_UTIL.NONFINALAUTHORITY, 1,
425: AME_UTIL.FINALAUTHORITYTYPENAME, 2,
426: AME_UTIL.SUBSTITUTIONTYPENAME, 1,

Line 431: FROM DUAL;

427: AME_UTIL.POSTAPPROVALTYPENAME, 1,
428: AME_UTIL.DYNAMICPOSTAPPROVER, 2,
429: X_ORDER_NUMBER)
430: INTO X_ACTION_TYPE_ORDER_NUMBER
431: FROM DUAL;
432: DBMS_LOCK.ALLOCATE_UNIQUE (LOCKNAME =>'AME_ACTION_TYPE_CONFIG.'||X_APPLICATION_ID||X_ACTION_TYPE_ID
433: ,LOCKHANDLE => LOCKHANDLE);
434: RETURNVALUE := DBMS_LOCK.REQUEST(LOCKHANDLE => LOCKHANDLE,TIMEOUT => 0
435: ,RELEASE_ON_COMMIT => TRUE);

Line 464: FROM DUAL

460: ,X_ACA_CREATED_BY
461: ,X_ACA_CREATION_DATE
462: ,0
463: ,1
464: FROM DUAL
465: WHERE NOT EXISTS (SELECT NULL
466: FROM AME_ACTION_TYPE_CONFIG
467: WHERE ACTION_TYPE_ID = X_ACTION_TYPE_ID
468: AND APPLICATION_ID = X_APPLICATION_ID

Line 521: FROM DUAL

517: ,X_ACA_CREATED_BY
518: ,X_ACA_CREATION_DATE
519: ,0
520: ,1
521: FROM DUAL
522: WHERE NOT EXISTS (SELECT NULL
523: FROM AME_APPROVAL_GROUP_CONFIG
524: WHERE APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID
525: AND APPLICATION_ID = X_APPLICATION_ID