[Home] [Help]
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,