APPS.AD_ZD_MVIEW dependencies on DBA_DEPENDENCIES

Line 1528: FROM dba_dependencies

1524:
1525: cursor depobjs is
1526: SELECT owner,
1527: name
1528: FROM dba_dependencies
1529: WHERE referenced_name=upper(p_name)
1530: AND referenced_owner=upper(p_owner)
1531: AND referenced_type=upper(nvl(p_type, referenced_type))
1532: AND type='MATERIALIZED VIEW';