DBA Data[Home] [Help]

APPS.HZ_MIXNM_DYNAMIC_PKG_GENERATOR dependencies on ALL_OBJECTS

Line 309: from sys.all_objects b

305: and a.type_subname = upper (p_entity_name) || '_REC_TYPE'
306: and a.data_level = 0
307: and a.object_id in (
308: select b.object_id
309: from sys.all_objects b
310: where b.object_name = 'HZ_PARTY_V2PUB'
311: and b.owner = l_apps_schema
312: and b.object_type = 'PACKAGE')) temp1, (
313: select column_name

Line 334: from sys.all_objects b

330: 'ACTUAL_CONTENT_SOURCE', 'APPLICATION_ID')
331: and aa.sequence > temp1.id
332: and aa.object_id in (
333: select b.object_id
334: from sys.all_objects b
335: where b.object_name = 'HZ_PARTY_V2PUB'
336: and b.owner = l_apps_schema
337: and b.object_type = 'PACKAGE')
338: and aa.argument_name = party.column_name (+)