APPS.AD_ZD_PREP dependencies on DBA_TYPES

Line 624: dba_types nt

620: -- types that reference the specified type and have a replacement in APPS_NE
621: cursor C_TYPE_REFS(XX_TYPE_OWNER varchar2, XX_TYPE_NAME varchar2) is
622: select ot.owner, ot.name
623: from dba_dependencies ot,
624: dba_types nt
625: where ot.type = 'TYPE'
626: and ot.referenced_owner= xx_type_owner
627: and ot.referenced_name = xx_type_name
628: and ot.referenced_type = 'TYPE'

Line 735: from dba_types

731: log(l_module, 'PROCEDURE', 'begin: '||x_owner||'.'||x_name ||', '|| x_new_owner);
732:
733: begin
734: select 1 into l_exist
735: from dba_types
736: where owner = x_owner
737: and type_name = x_name;
738: exception
739: when no_data_found then