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