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'