APPS.CSD_PARTIES_UTIL dependencies on HZ_CONTACT_POINTS

Line 56: FROM hz_contact_points

52:
53: CURSOR get_email_details IS
54: SELECT contact_point_id,
55: last_update_date
56: FROM hz_contact_points
57: WHERE owner_table_id = l_party_id
58: AND owner_table_name = 'HZ_PARTIES'
59: AND contact_point_type='EMAIL'
60: AND primary_flag='Y' ;

Line 280: FROM HZ_CONTACT_POINTS

276: l_phone_cnt_point_id NUMBER := p_phone_cnt_point_id;
277:
278: CURSOR get_phone_details IS
279: SELECT LAST_UPDATE_DATE
280: FROM HZ_CONTACT_POINTS
281: WHERE CONTACT_POINT_ID = l_phone_cnt_point_id;
282:
283: BEGIN
284: -- Standard Start of API savepoint