DBA Data[Home] [Help]

APPS.BEN_DERIVABLE_FACTOR dependencies on DBA_TAB_COLUMNS

Line 33: reference to dba_tab_columns using synonyms

29: to cursor c1 in elig_prfl_handler,
30: the value is got by the
31: call to fnd_installation.get_app_info
32: 15-Nov-2012 amnaraya 120.0.12020000.2 Bug 15876152: Changed all_tab_columns
33: reference to dba_tab_columns using synonyms
34:
35:
36: */
37: --------------------------------------------------------------------------------

Line 61: from dba_tab_columns tab, user_synonyms syn

57: --
58: --Bug 15876152: Changed the cursor select statement
59: cursor c1 (p_tab_name varchar2, p_col_name varchar2,p_oracle_schema varchar2) is
60: select null
61: from dba_tab_columns tab, user_synonyms syn
62: where syn.synonym_name = upper(p_tab_name)
63: and tab.column_name = upper(p_col_name)
64: and tab.owner = syn.table_owner
65: and tab.table_name = syn.table_name