DBA Data[Home] [Help]

APPS.AD_ZD dependencies on DATABASE_PROPERTIES

Line 225: from database_properties

221: end if;
222:
223: /* Get default edition first */
224: select property_value into l_default
225: from database_properties
226: where property_name = 'DEFAULT_EDITION';
227:
228: if x_edition_type = 'RUN' then
229:

Line 469: , database_properties run /* run edition name */

465: and obj.type# not in (10, 0, 88)
466: and obj.remoteowner is null ) co
467: , dba_objects_ae oe /* old edition */
468: , dba_objects_ae re /* run edition */
469: , database_properties run /* run edition name */
470: where run.property_name = 'DEFAULT_EDITION'
471: /* run edition */
472: and re.owner = 'SYS'
473: and re.object_type = 'EDITION'

Line 643: from dba_editions oe, database_properties re

639: L_EMPTY varchar2(2);
640: -- Old Editions
641: cursor C_OLD_EDITIONS is
642: select oe.edition_name
643: from dba_editions oe, database_properties re
644: where re.property_name = 'DEFAULT_EDITION'
645: and oe.edition_name < re.property_value
646: order by oe.edition_name;
647: begin