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: select column_name

Line 920: from sys.all_objects b

916: 'ACTUAL_CONTENT_SOURCE', 'APPLICATION_ID')
917: and aa.sequence > temp1.id
918: and aa.object_id in (
919: select b.object_id
920: from sys.all_objects b
921: where b.object_name = 'HZ_PARTY_V2PUB'
922: and b.owner = p_apps_schema
923: and b.object_type = 'PACKAGE')
924: and aa.argument_name = party.column_name (+)