DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on HZ_CONTACT_POINTS

Line 7207: FROM hz_contact_points cp

7203: AND party_role_code = p_external_party_role;
7204:
7205: CURSOR tca_email_csr(l_contact_id NUMBER) IS
7206: SELECT email_address
7207: FROM hz_contact_points cp
7208: WHERE cp.owner_table_id = l_contact_id
7209: AND cp.owner_table_name='HZ_PARTIES'
7210: AND cp.contact_point_type = 'EMAIL';
7211: BEGIN