DBA Data[Home] [Help]

APPS.HZ_USER_PARTY_UTILS dependencies on HZ_RELATIONSHIPS

Line 134: hz_relationships rel,

130: SELECT per.party_id,
131: per.party_type,
132: per.status
133: FROM hz_contact_points cp,
134: hz_relationships rel,
135: hz_parties per
136: WHERE upper(cp.email_address) = UPPER(l_email_address)
137: AND rel.party_id = cp.owner_table_id
138: AND cp.owner_table_name = 'HZ_PARTIES'