DBA Data[Home] [Help]

APPS.BIS_VG_LOOKUP dependencies on USER_SYNONYMS

Line 1109: from user_synonyms syn, all_tab_columns col

1105: where object_name = UPPER(p_table);
1106:
1107: cursor l_tab_view_cursor is
1108: select 1
1109: from user_synonyms syn, all_tab_columns col
1110: where syn.synonym_name = UPPER(p_table)
1111: and syn.table_name = col.table_name
1112: and col.column_name = UPPER(p_column)
1113: and syn.table_owner = col.owner

Line 1123: from all_tab_columns a, user_synonyms u

1119: and col1.column_name = UPPER(p_column);
1120:
1121: cursor l_tab_syn_cursor is
1122: select 1
1123: from all_tab_columns a, user_synonyms u
1124: where u.synonym_name = UPPER(p_table)
1125: and u.table_name = a.table_name
1126: and a.owner = u.table_owner
1127: and a.column_name = UPPER(p_column)