APPS.CS_SERVICEREQUEST_PVT dependencies on HZ_PARTY_SITES

Line 821: hz_party_sites site

817: CURSOR c_addr_timezone IS
818: SELECT
819: loc.timezone_id
820: FROM
821: hz_party_sites site
822: , hz_locations loc
823: WHERE site.location_id = loc.location_id
824: AND site.party_id = p_contact_party_id
825: AND site.identifying_address_flag = 'Y'

Line 2221: FROM hz_party_sites

2217: --check if created by module = 'SR_ONETIME'
2218: -- fix for bug 8594093 to check for location as well Ranjan
2219: if l_service_request_rec.incident_location_type='HZ_PARTY_SITE' then
2220: SELECT count(party_site_id) into l_onetime_add_cnt
2221: FROM hz_party_sites
2222: WHERE party_site_id = l_service_request_rec.incident_location_id
2223: AND created_by_module = 'SR_ONETIME';
2224: elsif l_service_request_rec.incident_location_type='HZ_LOCATION' then
2225: SELECT count(location_id) into l_onetime_add_cnt

Line 4839: FROM hz_party_sites

4835: --check if created by module = 'SR_ONETIME'
4836: -- fix for bug 8594093 to check for location as well Ranjan
4837: if l_service_request_rec.incident_location_type='HZ_PARTY_SITE' then
4838: SELECT count(party_site_id) into G_ONETIME_ADD_CNT
4839: FROM hz_party_sites
4840: WHERE party_site_id = l_service_request_rec.incident_location_id
4841: AND created_by_module = 'SR_ONETIME';
4842: elsif l_service_request_rec.incident_location_type='HZ_LOCATION' then
4843: SELECT count(location_id) into G_ONETIME_ADD_CNT

Line 4850: FROM hz_party_sites

4846: AND created_by_module = 'SR_ONETIME';
4847: end if;
4848: /*
4849: SELECT count(party_site_id) into G_ONETIME_ADD_CNT
4850: FROM hz_party_sites
4851: WHERE party_site_id = l_service_request_rec.incident_location_id
4852: AND created_by_module = 'SR_ONETIME';
4853: */
4854:

Line 5575: FROM hz_party_sites

5571: --siahmed start of code for creating onetime address
5572: --check if created by module = 'SR_ONETIME'
5573: /*
5574: SELECT count(party_site_id) into l_onetime_add_cnt
5575: FROM hz_party_sites
5576: WHERE party_site_id = l_service_request_rec.incident_location_id
5577: AND created_by_module = 'SR_ONETIME';
5578: */
5579: IF ((l_service_request_rec.incident_location_id IS NULL ) AND

Line 22687: l_party_site_number hz_party_sites.party_site_number%TYPE;

22683: l_province hz_locations.province%TYPE;
22684: l_country hz_locations.country%TYPE;
22685: l_postal_plus4_code hz_locations.postal_plus4_code%TYPE;
22686: l_address_lines_phonetic hz_locations.address_lines_phonetic%TYPE;
22687: l_party_site_number hz_party_sites.party_site_number%TYPE;
22688: l_party_site_name hz_party_sites.party_site_name%TYPE;
22689: l_addressee hz_party_sites.addressee%TYPE;
22690:
22691: BEGIN

Line 22688: l_party_site_name hz_party_sites.party_site_name%TYPE;

22684: l_country hz_locations.country%TYPE;
22685: l_postal_plus4_code hz_locations.postal_plus4_code%TYPE;
22686: l_address_lines_phonetic hz_locations.address_lines_phonetic%TYPE;
22687: l_party_site_number hz_party_sites.party_site_number%TYPE;
22688: l_party_site_name hz_party_sites.party_site_name%TYPE;
22689: l_addressee hz_party_sites.addressee%TYPE;
22690:
22691: BEGIN
22692: SELECT a.location_id,

Line 22689: l_addressee hz_party_sites.addressee%TYPE;

22685: l_postal_plus4_code hz_locations.postal_plus4_code%TYPE;
22686: l_address_lines_phonetic hz_locations.address_lines_phonetic%TYPE;
22687: l_party_site_number hz_party_sites.party_site_number%TYPE;
22688: l_party_site_name hz_party_sites.party_site_name%TYPE;
22689: l_addressee hz_party_sites.addressee%TYPE;
22690:
22691: BEGIN
22692: SELECT a.location_id,
22693: a.address1,

Line 22730: hz_party_sites b

22726: l_addressee,
22727: l_loc_object_version_number,
22728: l_ps_object_version_number
22729: from hz_locations a,
22730: hz_party_sites b
22731: where b.party_site_id = l_service_req_rec.incident_location_id
22732: and b.location_id = a.location_id
22733: and b.created_by_module = a.created_by_module;
22734: