DBA Data[Home] [Help]

APPS.HRDATETH dependencies on ALL_SYNONYMS

Line 82: -- from all_synonyms SYN

78: -- has select privileges. So, the SQL should be:
79: --
80: -- select 1
81: -- into l_temp
82: -- from all_synonyms SYN
83: -- , table_privileges PRIV
84: -- where SYN.table_name = l_table_name
85: -- and SYN.owner in ('PUBLIC', user)
86: -- and PRIV.table_name = SYN.table_name

Line 99: from all_synonyms SYN

95: --
96: begin
97: select 1
98: into l_temp
99: from all_synonyms SYN
100: where SYN.table_name = l_table_name
101: and SYN.owner in ('PUBLIC', user)
102: and rownum = 1;
103: --