APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_LOCATIONS

Line 759: From hz_locations hzl,hz_party_sites hps

755: AND site_use_type = Site_type;
756:
757: CURSOR c_location(l_party_site_id NUMBER) IS
758: Select hzl.city
759: From hz_locations hzl,hz_party_sites hps
760: Where hps.party_site_id = p_party_site_id
761: And hzl.location_id = hps.location_id;
762:
763: