DBA Data[Home] [Help]

APPS.HZ_MIXNM_REGISTRY_PUB dependencies on ALL_OBJECTS

Line 895: from sys.all_objects b

891: and a.type_subname = upper (p_name) || '_REC_TYPE'
892: and a.data_level = 0
893: and a.object_id in (
894: select b.object_id
895: from sys.all_objects b
896: where b.object_name = 'HZ_PARTY_V2PUB'
897: and b.owner = p_apps_schema
898: and b.object_type = 'PACKAGE')) temp1, (
899: --Bug 15893080 - Remove direct access from all_tab_columns

Line 942: from sys.all_objects b

938: 'ACTUAL_CONTENT_SOURCE', 'APPLICATION_ID')
939: and aa.sequence > temp1.id
940: and aa.object_id in (
941: select b.object_id
942: from sys.all_objects b
943: where b.object_name = 'HZ_PARTY_V2PUB'
944: and b.owner = p_apps_schema
945: and b.object_type = 'PACKAGE')
946: and aa.argument_name = party.column_name (+)