DBA Data[Home] [Help]

APPS.FEM_WEBADI_TABLES_UTILS_PVT dependencies on USER_SYNONYMS

Line 1983: where owner = (select table_owner from user_synonyms where synonym_name = p_table_name)

1979: l_data_type varchar2(20);
1980:
1981: cursor CUR_INTF_COLUMNS is
1982: select column_name,data_type,nullable from dba_tab_columns
1983: where owner = (select table_owner from user_synonyms where synonym_name = p_table_name)
1984: and table_name = p_table_name
1985: order by nullable asc,data_type desc,column_name asc;
1986:
1987: begin

Line 2801: where owner = (select table_owner from user_synonyms where synonym_name = l_intf_table_name)

2797: select interface_table_name into l_intf_table_name from fem_tables_b
2798: where table_name = p_table_name;
2799:
2800: select count(1) into l_total_columns from dba_tab_columns
2801: where owner = (select table_owner from user_synonyms where synonym_name = l_intf_table_name)
2802: and table_name = l_intf_table_name;
2803:
2804: exception
2805: when NO_DATA_FOUND then