APPS.AD_ZD_TABLE dependencies on DBA_TAB_PRIVS

Line 326: dba_tab_privs tpt

322: , tpt.privilege
323: , tpt.grantable
324: , tpt.hierarchy
325: from
326: dba_tab_privs tpt
327: where tpt.owner = p_table_owner
328: and tpt.table_name = p_table_name
329: and tpt.privilege in ('SELECT', 'UPDATE', 'INSERT', 'DELETE', 'DEBUG')
330: and tpt.grantee <> 'SYSTEM'

Line 333: from dba_tab_privs tpv

329: and tpt.privilege in ('SELECT', 'UPDATE', 'INSERT', 'DELETE', 'DEBUG')
330: and tpt.grantee <> 'SYSTEM'
331: and not exists
332: ( select 'x'
333: from dba_tab_privs tpv
334: where tpv.owner = tpt.owner
335: and tpv.table_name = p_view_name
336: and tpv.grantee = tpt.grantee
337: and tpv.privilege = tpt.privilege