DBA Data[Home] [Help]

APPS.FND_OAM_USER_INFO dependencies on HZ_RELATIONSHIPS

Line 177: from hz_relationships rel

173: L_CUST_PERSON_PARTY_ID number;
174: begin
175: select rel.subject_id
176: into l_cust_person_party_id
177: from hz_relationships rel
178: where rel.party_id = p_customer_id
179: and rel.subject_table_name = 'HZ_PARTIES'
180: and rel.subject_type = 'PERSON'
181: and rel.object_table_name = 'HZ_PARTIES'