DBA Data[Home] [Help]

APPS.HZ_USER_PARTY_UTILS dependencies on HZ_RELATIONSHIPS

Line 114: hz_relationships rel,

110: SELECT per.party_id,
111: per.party_type,
112: per.status
113: FROM hz_contact_points cp,
114: hz_relationships rel,
115: hz_parties per
116: WHERE upper(cp.email_address) = UPPER(l_email_address)
117: AND rel.party_id = cp.owner_table_id
118: AND cp.owner_table_name = 'HZ_PARTIES'