APPS.PVX_MISC_PVT dependencies on HZ_LOCATIONS

Line 685: ,hz_locations HZL

681: ,HZL.province
682: ,HZL.county
683: ,HZL.country
684: FROM hz_party_sites HZPS
685: ,hz_locations HZL
686: WHERE
687: HZPS.location_id = HZL.location_id(+)
688: AND HZPS.identifying_address_flag(+) = 'Y'
689: AND HZPS.party_site_id = curvar_party_site_id;