APPS.CSI_INTERFACE_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 2885: FROM hz_cust_site_uses_all hcsu,

2881: nvl(x_source_line_rec.ib_current_loc,'!@#') <> 'INSTALL_BASE'
2882: THEN
2883: SELECT hcas.party_site_id
2884: INTO x_source_line_rec.ship_to_party_site_id
2885: FROM hz_cust_site_uses_all hcsu,
2886: hz_cust_acct_sites_all hcas
2887: WHERE hcsu.site_use_id = x_source_line_rec.ib_current_loc_id -- ship_to_address_id
2888: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
2889: END IF;

Line 2898: FROM hz_cust_site_uses_all hcsu,

2894: nvl(x_source_line_rec.ib_install_loc,'!@#') <> 'INSTALL_BASE'
2895: THEN
2896: SELECT hcas.party_site_id
2897: INTO x_source_line_rec.install_to_party_site_id
2898: FROM hz_cust_site_uses_all hcsu,
2899: hz_cust_acct_sites_all hcas
2900: WHERE hcsu.site_use_id = x_source_line_rec.ib_install_loc_id
2901: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
2902: END IF;

Line 3013: FROM hz_cust_site_uses_all hcsu,

3009:
3010: IF x_source_line_rec.ship_to_address_id is not null THEN
3011: SELECT hcas.party_site_id
3012: INTO x_source_line_rec.ship_to_party_site_id
3013: FROM hz_cust_site_uses_all hcsu,
3014: hz_cust_acct_sites_all hcas
3015: WHERE hcsu.site_use_id = x_source_line_rec.ship_to_address_id
3016: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
3017: END IF;