APPS.CSI_SYSTEMS_PVT dependencies on HZ_PARTY_SITES

Line 4982: FROM hz_cust_site_uses_all--hz_party_sites

4978: THEN
4979: BEGIN
4980: SELECT 'x'
4981: INTO l_dummy
4982: FROM hz_cust_site_uses_all--hz_party_sites
4983: WHERE site_use_id = p_ship_to_site_use_id
4984: AND site_use_code = 'SHIP_TO';
4985: EXCEPTION
4986: WHEN no_data_found THEN

Line 4999: FROM hz_cust_site_uses_all --hz_party_sites

4995: THEN
4996: BEGIN
4997: SELECT 'x'
4998: INTO l_dummy
4999: FROM hz_cust_site_uses_all --hz_party_sites
5000: WHERE site_use_id = p_ship_to_site_use_id
5001: AND site_use_code = 'SHIP_TO';
5002: EXCEPTION
5003: WHEN no_data_found THEN

Line 5117: FROM hz_party_sites

5113: THEN
5114: BEGIN
5115: SELECT 'x'
5116: INTO l_dummy
5117: FROM hz_party_sites
5118: WHERE party_site_id=p_install_site_use_id;
5119: EXCEPTION
5120: WHEN no_data_found THEN
5121: fnd_message.set_name('CSI', 'CSI_INVALID_INSTALL_ID');

Line 5133: FROM hz_party_sites

5129: THEN
5130: BEGIN
5131: SELECT 'x'
5132: INTO l_dummy
5133: FROM hz_party_sites
5134: WHERE party_site_id=p_install_site_use_id;
5135: EXCEPTION
5136: WHEN no_data_found THEN
5137: fnd_message.set_name('CSI', 'CSI_INVALID_INSTALL_ID');

Line 5878: ,HZ_PARTY_SITES hps

5874: ,p_system_header_tbl(sys_row).ship_to_location_id
5875: ,p_system_header_tbl(sys_row).ship_to_site_number
5876: FROM HZ_CUST_SITE_USES_ALL hzsu
5877: ,HZ_CUST_ACCT_SITES_ALL hzca
5878: ,HZ_PARTY_SITES hps
5879: ,HZ_PARTIES hzp
5880: ,HZ_LOCATIONS hls
5881: WHERE hzsu.site_use_id = p_system_header_tbl(sys_row).ship_to_site_use_id
5882: AND hzca.cust_acct_site_id = hzsu.cust_acct_site_id

Line 5927: ,HZ_PARTY_SITES hps

5923: ,p_system_header_tbl(sys_row).bill_to_location_id
5924: ,p_system_header_tbl(sys_row).bill_to_site_number
5925: FROM HZ_CUST_SITE_USES_ALL hzsu
5926: ,HZ_CUST_ACCT_SITES_ALL hzca
5927: ,HZ_PARTY_SITES hps
5928: ,HZ_PARTIES hzp
5929: ,HZ_LOCATIONS hls
5930: WHERE hzsu.site_use_id = p_system_header_tbl(sys_row).bill_to_site_use_id
5931: AND hzca.cust_acct_site_id = hzsu.cust_acct_site_id

Line 5974: FROM HZ_PARTY_SITES hps

5970: ,p_system_header_tbl(sys_row).install_country
5971: ,p_system_header_tbl(sys_row).install_description
5972: ,p_system_header_tbl(sys_row).install_location_id
5973: ,p_system_header_tbl(sys_row).install_site_number
5974: FROM HZ_PARTY_SITES hps
5975: ,HZ_PARTIES hzp
5976: ,HZ_LOCATIONS hls
5977: WHERE hps.party_site_id = p_system_header_tbl(sys_row).install_site_use_id
5978: AND hps.party_id = hzp.party_id