DBA Data[Home] [Help]

APPS.AMS_CTD_UTIL_PKG dependencies on DBA_TAB_COLUMNS

Line 15: -- ANNSRINI - 15-NOV-2012 - Fix for bug 15876260 - Replaced all_tab_columns with user_synonyms and dba_tab_columns

11: -- This package contains utility methods for CTD
12: --
13: -- History
14: --
15: -- ANNSRINI - 15-NOV-2012 - Fix for bug 15876260 - Replaced all_tab_columns with user_synonyms and dba_tab_columns
16: --
17: -- NOTE
18: --
19: -- End of Comments

Line 88: FROM user_synonyms syn, dba_tab_columns col

84: AND COLUMN_NAME = 'SURVEY_TYPE'
85: AND OWNER = p_table_owner; */
86:
87: SELECT 'Y'
88: FROM user_synonyms syn, dba_tab_columns col
89: WHERE syn.synonym_name = 'IES_SVY_SURVEYS_ALL'
90: AND col.owner = syn.table_owner
91: AND col.table_name = syn.table_name
92: --AND col.owner = p_table_owner