APPS.OKL_CS_TRANSFER_ASSUMPTION_PVT dependencies on HZ_CONTACT_POINTS

Line 622: FROM hz_contact_points

618:
619: --rkraya added for bug:2451527
620: CURSOR c_phone(p_party_id IN NUMBER) IS
621: SELECT decode(nvl(phone_country_code,''),(phone_country_code || '-'),'') || phone_area_code || phone_number phone
622: FROM hz_contact_points
623: WHERE owner_table_id = p_party_id
624: AND contact_point_type = 'PHONE';
625:
626: