APPS.HZ_MERGE_UTIL dependencies on HZ_LOCATIONS

Line 262: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l

258: CURSOR c_get_desc IS
259: SELECT nvl(ps.party_site_name, ps.party_site_number) || '(Address: ' ||
260: l.address1 || ',' ||l.address2||','||l.address3||','||l.address4||','|| l.city ||
261: ',' || l.county || ','|| l.state || ', ' || l.province || ','||l.postal_code || ',' || l.country||')'
262: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l
263: WHERE ps.party_site_id = p_party_site_id
264: AND ps.location_id = l.location_id;
265:
266: l_ps_address VARCHAR2(2000);