APPS.PV_PARTNER_ACCNT_MGMT_PVT dependencies on HZ_PARTY_SITES

Line 454: From hz_locations hzl,hz_party_sites hps

450: AND site_use_type = l_Site_type;
451:
452: CURSOR C_location(l_party_site_id NUMBER) IS
453: Select hzl.city
454: From hz_locations hzl,hz_party_sites hps
455: Where hps.party_site_id = l_party_site_id
456: And hzl.location_id = hps.location_id;
457:
458: