DBA Data[Home] [Help]

APPS.ASO_OPP_QTE_PUB dependencies on HZ_CONTACT_POINTS

Line 191: FROM hz_contact_points

187: AND lead_line_id = p_lead_line_id;
188:
189: CURSOR C_phone (p_party_id number) is
190: SELECT contact_point_id
191: FROM hz_contact_points
192: WHERE owner_table_id = p_party_id
193: AND owner_table_name = 'HZ_PARTIES'
194: AND contact_point_type = 'PHONE'
195: AND status = 'A'