Need to change R12 code containing references to tables zx_accounts and zx_registrations for 11i com

Hello All!

We have a piece of code in R12 that references ables zx_accounts and zx_registrations for fetching some data.

The exact piece of code is -

SELECT DISTINCT zr.rep_party_tax_name,

                          address_line_1,

                          address_line_2,

                          town_or_city,

                          postal_code,

                          ter.territory_code

            INTO v_location_code,

                 v_address1,

                 v_address2,

                 v_city,

                 v_postal_code,

                 v_country_code

            FROM zx_accounts          za,

                 zx_registrations     zr,

                 gl_code_combinations gcc,

                 hr_locations         hr,

                 fnd_territories_tl   ter

           WHERE za.tax_account_entity_id = zr.registration_id

             AND za.tax_account_ccid = gcc.code_combination_id

             AND hr.location_id = zr.legal_location_id