APPS.IBU_SR_UTIL dependencies on HZ_CONTACT_POINTS

Line 349: CURSOR C1 IS SELECT phone_number FROM hz_contact_points where owner_table_id = party_site_id and owner_table_name = 'HZ_PARTY_SITES' and contact_point_type = 'PHONE' order by primary_flag desc,creation_date asc;

345:
346: /*added for 12.1.2 enhancement bug8245975*/
347: function return_primary(party_site_id IN NUMBER) return varchar2 is
348: l_phone varchar2(100);
349: CURSOR C1 IS SELECT phone_number FROM hz_contact_points where owner_table_id = party_site_id and owner_table_name = 'HZ_PARTY_SITES' and contact_point_type = 'PHONE' order by primary_flag desc,creation_date asc;
350: BEGIN
351: FOR R IN C1
352: LOOP
353: l_phone:= R.phone_number;