DBA Data[Home] [Help]

APPS.FA_ASSET_TRACE_PKG dependencies on USER_SYNONYMS

Line 113: FROM DBA_OBJECTS OBJ, USER_SYNONYMS SYN

109:
110: /* Added for Bug 16266481 / 16053785 */
111: cursor c_playload_mesg is
112: SELECT OWNER||'.'||OBJECT_NAME
113: FROM DBA_OBJECTS OBJ, USER_SYNONYMS SYN
114: WHERE OBJ.OBJECT_NAME = UPPER('GAT_message_type')
115: AND OBJ.OBJECT_TYPE = 'TYPE'
116: AND SYN.SYNONYM_NAME = OBJ.OBJECT_NAME
117: AND OBJ.OWNER = SYN.TABLE_OWNER