APPS.OKC_DELIVERABLE_WF_PVT dependencies on HZ_CONTACT_POINTS

Line 355: FROM hz_contact_points hc

351: and person.party_id = p_external_contact;
352:
353: CURSOR ext_user_email(x NUMBER) IS
354: SELECT hc.email_address
355: FROM hz_contact_points hc
356: WHERE hc.owner_table_name = 'HZ_PARTIES'
357: AND hc.primary_flag = 'Y'
358: AND hc.contact_point_type = 'EMAIL'
359: AND hc.owner_table_id = x;