DBA Data[Home] [Help]

APPS.POS_PARTY_MANAGEMENT_PKG dependencies on HZ_CONTACT_POINTS

Line 212: FROM hz_contact_points

208: l_msg_data VARCHAR2(3000);
209:
210: CURSOR l_cur IS
211: SELECT 1
212: FROM hz_contact_points
213: WHERE owner_table_id = p_partyid
214: AND upper(email_address) = upper(p_emailaddress)
215: AND owner_table_name = 'HZ_PARTIES'
216: AND status = 'A'