SYS.AD_ZD_SYS dependencies on DATABASE_PROPERTIES

Line 108: database_properties RUN

104: select oe.object_name edition_name
105: from
106: dba_objects_ae oe,
107: dba_objects_ae re,
108: database_properties RUN
109: where run.property_name = 'DEFAULT_EDITION'
110: /* run edition */
111: and re.owner = 'SYS'
112: and re.object_type = 'EDITION'

Line 153: from database_properties

149: end if;
150:
151: /* Get default edition first */
152: select property_value into l_default
153: from database_properties
154: where property_name = 'DEFAULT_EDITION';
155:
156: if (l_edition = l_default) then
157: log(c_module, 'ERROR', 'Cannot drop RUN edition');

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

348: and obj.type# not in (10, 0)
349: and obj.remoteowner is null ) co
350: , dba_objects_ae oe /* old edition */
351: , dba_objects_ae re /* run edition */
352: , database_properties run /* run edition name */
353: where run.property_name = 'DEFAULT_EDITION'
354: /* run edition */
355: and re.owner = 'SYS'
356: and re.object_type = 'EDITION'

Line 494: from database_properties

490: L_PATCH_EDITION varchar2(30);
491: begin
492:
493: select property_value into l_default_edition
494: from database_properties
495: where property_name = 'DEFAULT_EDITION';
496:
497: begin
498: select aed.edition_name into l_patch_edition

Line 831: from database_properties

827:
828: l_current_edition := Sys_Context('Userenv', 'Current_Edition_Name');
829:
830: select property_value into l_default_edition
831: from database_properties
832: where property_name = 'DEFAULT_EDITION';
833:
834: begin
835: select aed.edition_name into l_patch_edition