APPS.CSI_INTERFACE_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 2919: FROM hz_cust_site_uses_all hcsu,

2915: nvl(x_source_line_rec.ib_current_loc,'!@#') <> 'INSTALL_BASE'
2916: THEN
2917: SELECT hcas.party_site_id
2918: INTO x_source_line_rec.ship_to_party_site_id
2919: FROM hz_cust_site_uses_all hcsu,
2920: hz_cust_acct_sites_all hcas
2921: WHERE hcsu.site_use_id = x_source_line_rec.ib_current_loc_id -- ship_to_address_id
2922: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
2923: END IF;

Line 2932: FROM hz_cust_site_uses_all hcsu,

2928: nvl(x_source_line_rec.ib_install_loc,'!@#') <> 'INSTALL_BASE'
2929: THEN
2930: SELECT hcas.party_site_id
2931: INTO x_source_line_rec.install_to_party_site_id
2932: FROM hz_cust_site_uses_all hcsu,
2933: hz_cust_acct_sites_all hcas
2934: WHERE hcsu.site_use_id = x_source_line_rec.ib_install_loc_id
2935: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
2936: END IF;

Line 3047: FROM hz_cust_site_uses_all hcsu,

3043:
3044: IF x_source_line_rec.ship_to_address_id is not null THEN
3045: SELECT hcas.party_site_id
3046: INTO x_source_line_rec.ship_to_party_site_id
3047: FROM hz_cust_site_uses_all hcsu,
3048: hz_cust_acct_sites_all hcas
3049: WHERE hcsu.site_use_id = x_source_line_rec.ship_to_address_id
3050: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
3051: END IF;