APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_LOCATIONS

Line 762: From hz_locations hzl,hz_party_sites hps

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