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
314: from sys.all_tab_columns c
315: where c.table_name = 'HZ_PARTIES'
316: and c.owner = l_ar_schema
317: and exists (
318: select null
315: where c.table_name = 'HZ_PARTIES'
316: and c.owner = l_ar_schema
317: and exists (
318: select null
319: from sys.all_tab_columns c2
320: where c2.owner = l_ar_schema
321: and c2.column_name = c.column_name
322: and c2.table_name = 'HZ_' ||upper (p_entity_name) || '_PROFILES')
323: and c.column_name not like 'ATTRIBUTE%'