DBA Data[Home] [Help]

APPS.BEN_DERIVABLE_RATE dependencies on DBA_TAB_COLUMNS

Line 45: TO DBA_TAB_COLUMNS

41: 15-Feb-2004 vvprabhu 115.8 Initialized l_application_short_name to BEN
42: 04-Jun-2004 abparekh 115.9 Bug : 3667163 - Corrected number of arguments
43: in call to execute immediate in RATE_PRFL_HANDLER
44: 15-Nov-2012 usaraswa 120.0.12020000.2 Bug 15876152 CHANGED ALL_TAB_COLUMNS REFERENCE
45: TO DBA_TAB_COLUMNS
46:
47:
48: */
49: --------------------------------------------------------------------------------

Line 68: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start

64: l_oracle_schema varchar2(30);
65: l_return boolean;
66:
67: --
68: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start
69: cursor c1 (p_tab_name varchar2, p_col_name varchar2,p_oracle_schema varchar2) is
70:
71: /* select null
72: from all_tab_columns

Line 78: from user_synonyms syn,dba_tab_columns col

74: and column_name = upper(p_col_name)
75: and owner = upper(p_oracle_schema);*/
76:
77: select null
78: from user_synonyms syn,dba_tab_columns col
79: where syn.synonym_name = upper(p_tab_name)
80: and col.owner = syn.table_owner
81: and col.table_name = syn.table_name
82: and COL.column_name = upper(p_col_name)