DBA Data[Home] [Help]

APPS.HZ_MERGE_DUP_PVT dependencies on HZ_CODE_ASSIGNMENTS

Line 407: from hz_code_assignments code

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