DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on HZ_CODE_ASSIGNMENTS

Line 6217: From HZ_RELATIONSHIP_TYPES reltype, HZ_CODE_ASSIGNMENTS code

6213: AND hp_rltn.party_id = p_party_id
6214: AND hp_contact.party_id = hp_rltn.subject_id
6215: AND hp_contact.party_type = 'PERSON'
6216: AND hp_rltn.relationship_code IN ( Select distinct reltype.forward_rel_code
6217: From HZ_RELATIONSHIP_TYPES reltype, HZ_CODE_ASSIGNMENTS code
6218: Where code.class_category = 'RELATIONSHIP_TYPE_GROUP'
6219: and code.class_code = 'PARTY_REL_GRP_CONTACTS'
6220: and code.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
6221: and code.owner_table_id = reltype.relationship_type_id