APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on HZ_PARTY_SITES

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 312: select s.party_site_id from hz_party_sites s,

308: --
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: --

Line 826: FROM hz_party_sites

822: SELECT timezone_id
823: INTO l_timezone_id
824: FROM hz_locations
825: WHERE location_id = ( SELECT location_id
826: FROM hz_party_sites
827: WHERE party_id = p_contact_id
828: AND identifying_address_flag = 'Y'
829: AND status = 'A' ) ;
830: end if;

Line 1699: FROM hz_party_sites a, hz_locations b

1695: l_INCIDENT_TIMEZONE_ID NUMBER DEFAULT NULL;
1696:
1697: CURSOR Incident_party_site_timezone IS
1698: SELECT b.timezone_id
1699: FROM hz_party_sites a, hz_locations b
1700: WHERE a.location_id = b.location_id
1701: AND a.party_site_id = p_incident_location_id ;
1702:
1703: -- Cursor to derive time zone for location

Line 1758: FROM hz_party_sites a, hz_locations b

1754:
1755: -- Cursor to derive time zone for Primary Contact address
1756: CURSOR Contact_timezone IS
1757: SELECT b.timezone_id
1758: FROM hz_party_sites a, hz_locations b
1759: WHERE a.location_id = b.location_id
1760: AND a.identifying_address_flag = 'Y'
1761: AND a.party_id = p_contact_party_id ;
1762:

Line 1822: FROM hz_party_sites a, hz_locations b

1818: l_customer_timezone_id NUMBER DEFAULT NULL;
1819:
1820: CURSOR Cur_Customer_Timezone IS
1821: SELECT b.timezone_id
1822: FROM hz_party_sites a, hz_locations b
1823: WHERE a.location_id = b.location_id
1824: AND a.identifying_address_flag = 'Y'
1825: AND a.party_id = p_customer_id ;
1826: