APPS.OKL_DEAL_ASSET_PVT dependencies on HZ_PARTY_SITE_USES

Line 800: hz_party_site_uses hpu

796: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
797: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) party_site_name
798: FROM hz_locations hl,
799: hz_party_sites hps,
800: hz_party_site_uses hpu
801: WHERE hpu.party_site_use_id = p_party_site_use_id
802: AND hps.party_site_id = hpu.party_site_id
803: AND hl.location_id = hps.location_id;
804: