APPS.OKL_CS_TRANSFER_ASSUMPTION_PVT dependencies on HZ_CONTACT_POINTS

Line 576: FROM hz_contact_points

572:
573: --rkraya added for bug:2451527
574: CURSOR c_phone(p_party_id IN NUMBER) IS
575: SELECT decode(nvl(phone_country_code,''),(phone_country_code || '-'),'') || phone_area_code || phone_number phone
576: FROM hz_contact_points
577: WHERE owner_table_id = p_party_id
578: AND contact_point_type = 'PHONE';
579:
580: