APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_CONTACT_POINTS

Line 14: FROM hz_contact_points

10: object_type VARCHAR2(30);
11:
12: CURSOR get_contact_point_type IS
13: SELECT contact_point_type
14: FROM hz_contact_points
15: WHERE contact_point_id = p_table_id;
16: BEGIN
17: object_type := NULL;
18: object_type := HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(p_table_name,p_table_id);

Line 21: IF p_table_name = 'HZ_CONTACT_POINTS' THEN

17: object_type := NULL;
18: object_type := HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(p_table_name,p_table_id);
19:
20: IF object_type IS null THEN
21: IF p_table_name = 'HZ_CONTACT_POINTS' THEN
22: OPEN get_contact_point_type;
23: FETCH get_contact_point_type INTO object_type;
24: CLOSE get_contact_point_type;
25: ELSIF p_table_name = 'HZ_ORG_CONTACTS' THEN