DBA Data[Home] [Help]

APPS.HZ_MIXNM_DYNAMIC_PKG_GENERATOR dependencies on ALL_OBJECTS

Line 370: from sys.all_objects b

366: and a.type_subname = upper (p_entity_name) || '_REC_TYPE'
367: and a.data_level = 0
368: and a.object_id in (
369: select b.object_id
370: from sys.all_objects b
371: where b.object_name = 'HZ_PARTY_V2PUB'
372: and b.owner = l_apps_schema
373: and b.object_type = 'PACKAGE')) temp1, (
374: --Bug 15893080 - Remove direct access from all_tab_columns

Line 416: from sys.all_objects b

412: 'ACTUAL_CONTENT_SOURCE', 'APPLICATION_ID')
413: and aa.sequence > temp1.id
414: and aa.object_id in (
415: select b.object_id
416: from sys.all_objects b
417: where b.object_name = 'HZ_PARTY_V2PUB'
418: and b.owner = l_apps_schema
419: and b.object_type = 'PACKAGE')
420: and aa.argument_name = party.column_name (+)