APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on HZ_PARTY_SITE_USES

Line 273: from hz_party_sites s, hz_locations l, hz_party_site_uses u

269: decode(l.address3,null,null,', '|| l.address3) || decode(l.address4,null,null,', '|| l.address4) ||
270: decode (l.city, null, null, ', '|| l.city) || decode(l.state,null,null,', ' || l.state) ||
271: decode(l.province,null,null,', ' || l.province) || decode(l.postal_code,null,null,' '
272: || l.postal_code) || decode(l.country,null,null,' ' || l.country)
273: from hz_party_sites s, hz_locations l, hz_party_site_uses u
274: where s.party_id=param_party_id and s.status='A' and s.location_id=l.location_id and
275: s.party_site_id=u.party_site_id and u.site_use_type=param_site_usage
276: and u.primary_per_type='Y' and u.status='A';
277: --

Line 313: hz_party_site_uses u where s.party_id=param_party_id and s.status='A' and

309: l_site_id NUMBER;
310:
311: CURSOR default_site(param_party_id NUMBER, param_site_usage VARCHAR2) is
312: select s.party_site_id from hz_party_sites s,
313: hz_party_site_uses u where s.party_id=param_party_id and s.status='A' and
314: s.party_site_id=u.party_site_id and u.site_use_type=param_site_usage
315: and u.primary_per_type='Y' and u.status='A';
316: --
317: begin