DBA Data[Home] [Help]

APPS.FND_OAM_USER_INFO dependencies on HZ_RELATIONSHIPS

Line 206: from hz_relationships rel

202: --hz_party_relationships
203:
204: select distinct rel.subject_id
205: into l_cust_person_party_id
206: from hz_relationships rel
207: where rel.party_id = p_customer_id
208: and rel.subject_table_name = 'HZ_PARTIES'
209: and rel.subject_type = 'PERSON'
210: and rel.object_table_name = 'HZ_PARTIES'