DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on HZ_CONTACT_POINTS

Line 6324: FROM hz_contact_points cp

6320: AND party_role_code = p_external_party_role;
6321:
6322: CURSOR tca_email_csr(l_contact_id NUMBER) IS
6323: SELECT email_address
6324: FROM hz_contact_points cp
6325: WHERE cp.owner_table_id = l_contact_id
6326: AND cp.owner_table_name='HZ_PARTIES'
6327: AND cp.contact_point_type = 'EMAIL';
6328: BEGIN