DBA Data[Home] [Help]

APPS.AD_MORG dependencies on DBA_TABLES

Line 82: dba_tables t

78: select 'table exists',t.owner
79: into l_dummy,
80: O_table_owner
81: from user_synonyms s,
82: dba_tables t
83: where s.synonym_name = upper(X_table_name)
84: and t.owner = s.table_owner
85: and t.table_name = s.table_name
86: and rownum = 1;

Line 162: l_table_owner dba_tables.owner%type;

158: l_oracle_schema varchar2(30) := null;
159: l_ign boolean;
160: l_conv_method varchar2(1);
161: l_num_rows number;
162: l_table_owner dba_tables.owner%type;
163: begin
164:
165: l_conv_method := 'S';
166: --

Line 272: from dba_tables

268:
269: begin
270: select num_rows
271: into l_num_rows
272: from dba_tables
273: where table_name = x_table_name
274: and owner= l_table_owner;
275: exception
276: when no_data_found then