DBA Data[Home] [Help]

APPS.PAY_EVENTS_WRAPPER dependencies on DBA_TAB_COLUMNS

Line 91: dba_tab_columns instead of all_tab_columns

87: referenced. Change these tables
88: to use a hash cache.
89: Andy Logue 13-FEB-2006 115.19 Schema clone for all_tab_columns.
90: nvankadh 28-NOV-2012 115.20 15882261 Modified few cursor definitions to refer to
91: dba_tab_columns instead of all_tab_columns
92: nvankadh 13-DEC-2012 115.21 15983018 Modified due to regression because of
93: the changes made for 15882261
94: ===============================================================================
95: */

Line 529: -- Bug 15882261 : Modified cursor defination to refer to dba_tab_columns

525: -- WHERE table_name = cp_name
526: -- AND column_name = cp_column
527: -- AND owner = cp_owner;
528:
529: -- Bug 15882261 : Modified cursor defination to refer to dba_tab_columns
530: -- instead of all_tab_columns
531:
532: CURSOR get_info(cp_name IN VARCHAR2,cp_column IN VARCHAR2,cp_owner IN VARCHAR2) IS
533: SELECT 'Y'

Line 534: FROM dba_tab_columns tab, user_synonyms syn

530: -- instead of all_tab_columns
531:
532: CURSOR get_info(cp_name IN VARCHAR2,cp_column IN VARCHAR2,cp_owner IN VARCHAR2) IS
533: SELECT 'Y'
534: FROM dba_tab_columns tab, user_synonyms syn
535: WHERE tab.table_name = syn.table_name
536: AND tab.owner = syn.table_owner
537: AND syn.synonym_name = cp_name
538: AND tab.column_name = cp_column