APPS.CSI_SYSTEMS_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 5049: FROM hz_cust_site_uses_all --hz_cust_acct_sites_all

5045: THEN
5046: BEGIN
5047: SELECT 'x'
5048: INTO l_dummy
5049: FROM hz_cust_site_uses_all --hz_cust_acct_sites_all
5050: WHERE site_use_id = p_bill_to_site_use_id
5051: AND site_use_code = 'BILL_TO';
5052: EXCEPTION
5053: WHEN no_data_found THEN

Line 5066: FROM hz_cust_site_uses_all --hz_cust_acct_sites_all

5062: THEN
5063: BEGIN
5064: SELECT 'x'
5065: INTO l_dummy
5066: FROM hz_cust_site_uses_all --hz_cust_acct_sites_all
5067: WHERE site_use_id = p_bill_to_site_use_id
5068: AND site_use_code = 'BILL_TO';
5069: EXCEPTION
5070: WHEN no_data_found THEN

Line 5877: ,HZ_CUST_ACCT_SITES_ALL hzca

5873: ,p_system_header_tbl(sys_row).ship_description
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

Line 5926: ,HZ_CUST_ACCT_SITES_ALL hzca

5922: ,p_system_header_tbl(sys_row).bill_description
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