DBA Data[Home] [Help]

APPS.AME_CONDITIONS_API dependencies on V$INSTANCE

Line 339: V$INSTANCE INSTANCE

335: function CREATE_CONDITION_KEY return VARCHAR2 as
336: cursor GET_DBID_CURSOR is
337: select to_char(DB.DBID)
338: from V$DATABASE DB,
339: V$INSTANCE INSTANCE
340: where upper(DB.NAME) = upper(INSTANCE.INSTANCE_NAME);
341: X_DATABASE_ID VARCHAR2(50);
342: X_NEW_CONDITION_KEY AME_CONDITIONS.CONDITION_KEY%TYPE;
343: X_CONDITION_COUNT NUMBER;