APPS.HZ_MERGE_DICTIONARY_PKG dependencies on ALL_OBJECTS

Line 27: FROM sys.ALL_OBJECTS

23: l_bool BOOLEAN;
24:
25: CURSOR c_table IS
26: SELECT 'Exists'
27: FROM sys.ALL_OBJECTS
28: WHERE OBJECT_NAME = p_parent_entity
29: -- AND OWNER = l_owner1
30: AND (OBJECT_TYPE = 'TABLE' OR OBJECT_TYPE = 'VIEW')
31: and rownum = 1;

Line 192: FROM sys.ALL_OBJECTS

188: l_temp VARCHAR2(255);
189: l_bool BOOLEAN;
190: CURSOR c_table IS
191: SELECT 'Exists'
192: FROM sys.ALL_OBJECTS
193: WHERE OBJECT_NAME = p_entity_name
194: AND (OBJECT_TYPE = 'TABLE' OR OBJECT_TYPE = 'VIEW')
195: and rownum = 1;
196: --and owner = l_owner1;