How to retrieve Geocode for a customer site in R12?

Hi,
In our customization in 11i we had used following query to fetch the geocode for a customer site. Can you please help me with R12 equivalent query for the same?

SELECT alv.attribute1
FROM ar.hz_cust_acct_sites_all hcasa,
ar.hz_party_sites hps,
ar.hz_locations hl,
apps.hz_loc_assignments hla,
aPPS.ar_location_combinations lcc,
apps.ar_location_values_v alv
WHERE hps.party_site_id = hcasa.party_site_id
AND hps.location_id = hl.location_id
AND hl.location_id = hla.location_id
AND hla.loc_id = lcc.location_id
AND alv.location_segment_id = lcc.location_id_segment_3 AND hcasa.CUST_ACCT_SITE_ID = &1