DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on HZ_CODE_ASSIGNMENTS

Line 6233: From HZ_RELATIONSHIP_TYPES reltype, HZ_CODE_ASSIGNMENTS code

6229: AND hp_rltn.party_id = p_party_id
6230: AND hp_contact.party_id = hp_rltn.subject_id
6231: AND hp_contact.party_type = 'PERSON'
6232: AND hp_rltn.relationship_code IN ( Select distinct reltype.forward_rel_code
6233: From HZ_RELATIONSHIP_TYPES reltype, HZ_CODE_ASSIGNMENTS code
6234: Where code.class_category = 'RELATIONSHIP_TYPE_GROUP'
6235: and code.class_code = 'PARTY_REL_GRP_CONTACTS'
6236: and code.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
6237: and code.owner_table_id = reltype.relationship_type_id