APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on HZ_LOCATIONS

Line 684: FROM HZ_PARTY_SITES SITE, HZ_LOCATIONS LOC

680:
681: CURSOR C_Get_Location(C_Address_Id NUMBER) IS
682: SELECT LOC.COUNTRY, LOC.STATE, LOC.PROVINCE, LOC.COUNTY,
683: LOC.CITY, LOC.POSTAL_CODE
684: FROM HZ_PARTY_SITES SITE, HZ_LOCATIONS LOC
685: WHERE SITE.PARTY_SITE_ID = c_address_id
686: AND SITE.LOCATION_ID = LOC.LOCATION_ID;
687:
688: