APPS.OKC_DELIVERABLE_WF_PVT dependencies on HZ_CONTACT_POINTS

Line 370: FROM hz_contact_points hc

366: and person.party_id = p_external_contact;
367:
368: CURSOR ext_user_email(x NUMBER) IS
369: SELECT hc.email_address
370: FROM hz_contact_points hc
371: WHERE hc.owner_table_name = 'HZ_PARTIES'
372: AND hc.primary_flag = 'Y'
373: AND hc.contact_point_type = 'EMAIL'
374: AND hc.owner_table_id = x;