DBA Data[Home] [Help]

APPS.HZ_MERGE_DUP_PVT dependencies on HZ_CODE_ASSIGNMENTS

Line 406: from hz_code_assignments code

402: IS
403:
404: cursor c_contact_rel(p_relationship_id NUMBER) IS
405: select count(distinct code.owner_table_id)
406: from hz_code_assignments code
407: where code.class_category = 'RELATIONSHIP_TYPE_GROUP'
408: and code.class_code = 'PARTY_REL_GRP_CONTACTS'
409: and code.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
410: and exists ( select 1 from hz_relationship_types rt,